BASE/39 Write not allowed in MariaDB

[nageswaragunupudi]

So you say the opposite is working with rowset.

Yes.

[MarioG]

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?

[MarioG]

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

muchas gracias

[MarioG]

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