BASE/39 Write not allowed in MariaDB

Re: BASE/39 Write not allowed in MariaDB

Postby nageswaragunupudi » Mon Jun 08, 2020 12:40 am

So you say the opposite is working with rowset.


Yes.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10620
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: BASE/39 Write not allowed in MariaDB

Postby MarioG » Fri Sep 18, 2020 1:50 am

Buenas noches
Tengo una tabla con la siguiente estructura en un campo:
Code: Select all  Expand view
id_categ     TINYINT(2) UNSIGNED ZEROFILL NOT NULL

He importado datos desde una hoja Excel y guardado los valores correspondientes, a este y otros campos, sin problemas.
Proceso que hago mediante oCn:Execute(...)

Ahora bien cuando Edito un registro mediante TDataRow() donde previo a modficarlo hago:
Code: Select all  Expand view
oPlayer:SetDefault( 3, 0, TRUE )
? "Prueba", oPlayer:id_categ:= 22

Entonces recibo el siguiente error
Error occurred at: 17/09/2020, 22:33:01
Error description: Error BASE/39 Escritura no autorizada: TDATAROW:id_categ
Args:
[ 1] = O TDATAROW

Cual es el problema?
Resistencia - "Ciudad de las Esculturas"
Chaco - Argentina
User avatar
MarioG
 
Posts: 1380
Joined: Fri Oct 14, 2005 1:28 pm
Location: Resistencia - Chaco - AR

Re: BASE/39 Write not allowed in MariaDB

Postby MarioG » Sat Sep 19, 2020 2:40 am

Por favor!
Como lo soluciono?... no puedo avanzar!

muchas gracias
Resistencia - "Ciudad de las Esculturas"
Chaco - Argentina
User avatar
MarioG
 
Posts: 1380
Joined: Fri Oct 14, 2005 1:28 pm
Location: Resistencia - Chaco - AR

Re: BASE/39 Write not allowed in MariaDB

Postby MarioG » Sat Sep 19, 2020 8:15 pm

Horizon wrote:Hi,

I think I found my mistake.

in oTb_YAPILAN:D_BOS(YENIKAYIT)
Code: Select all  Expand view
 oRec:SetDefault("YPL_BNK1", 3)
 

This procedure set my default variables to table fieldnames. I thought SetDefault is valid for FWMARIAROWSET like TDATAROW.

SetDefault also sets the fieldname as a readonly variable in FWMARIAROWSET Class.

Mr Rao. Can you confirm me? If it is I should change lots of lines in my application.

Edit :
Code: Select all  Expand view
 oRec:SetDefault("YPL_BNK1", 3, .F.)

I have changed to SetDefault like above and problem is solved. Mr. Rao, Can you confirm it?

Thanks.

Hello
I've the same problem!
is it the same coincidense? My field is in de 3rd position too
This is
id_categ TINYINT(2) UNSIGNED ZEROFILL NOT NULL

I do this, before Edit, but the error repeat:
Code: Select all  Expand view
oQryPly:SetDefault( "id_categ", 3, FALSE ), ;
oPlayer := TDataRow():New( oQryPly ), ::AgrEditaPlayer( oPlayer, oBrw, nPosFld, oQryPly


Please, what can a I do? I Can't continius
many thanks
Resistencia - "Ciudad de las Esculturas"
Chaco - Argentina
User avatar
MarioG
 
Posts: 1380
Joined: Fri Oct 14, 2005 1:28 pm
Location: Resistencia - Chaco - AR

Previous

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 24 guests