Page 2 of 2

Re: BASE/39 Write not allowed in MariaDB

Posted: Mon Jun 08, 2020 12:40 am
by nageswaragunupudi
So you say the opposite is working with rowset.
Yes.

Re: BASE/39 Write not allowed in MariaDB

Posted: Fri Sep 18, 2020 1:50 am
by MarioG
Buenas noches
Tengo una tabla con la siguiente estructura en un campo:

Code: Select all

id_categ     TINYINT(2) UNSIGNED ZEROFILL NOT NULL
He importado datos desde una hoja Excel y guardado los valores correspondientes, a este y _, sin problemas.
Proceso que hago mediante oCn:Execute(...)

Ahora bien cuando Edito un registro mediante TDataRow() donde previo a modficarlo hago:

Code: Select all

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?

Re: BASE/39 Write not allowed in MariaDB

Posted: Sat Sep 19, 2020 2:40 am
by MarioG
Por favor!
Como lo soluciono?... no puedo avanzar!

muchas gracias

Re: BASE/39 Write not allowed in MariaDB

Posted: Sat Sep 19, 2020 8:15 pm
by MarioG
Horizon wrote:Hi,

I think I found my mistake.

in oTb_YAPILAN:D_BOS(YENIKAYIT)

Code: Select all

  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

  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

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