topic-38899

Board index FiveWin for Harbour/xHarbour BASE/39 Write not allowed in MariaDB

Page: 1 2 (19 posts)

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: BASE/39 Write not allowed in MariaDB
Posted: Mon Jun 08, 2020 12:40 AM

So you say the opposite is working with rowset.

Yes.

Regards

G. N. Rao.

Hyderabad, India

MarioG

Posts: 1380

Joined: Fri Oct 14, 2005 01:28 PM

Re: BASE/39 Write not allowed in MariaDB
Posted: Fri Sep 18, 2020 01:50 AM

Buenas noches
Tengo una tabla con la siguiente estructura en un campo:

Code (fw): Select all Collapse

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 (fw): Select all Collapse

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

MarioG

Posts: 1380

Joined: Fri Oct 14, 2005 01:28 PM

Re: BASE/39 Write not allowed in MariaDB
Posted: Sat Sep 19, 2020 02:40 AM

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

muchas gracias

Resistencia - "Ciudad de las Esculturas"

Chaco - Argentina

MarioG

Posts: 1380

Joined: Fri Oct 14, 2005 01:28 PM

Re: BASE/39 Write not allowed in MariaDB
Posted: Sat Sep 19, 2020 08:15 PM

Horizon wrote:Hi,

I think I found my mistake.

in oTb_YAPILAN:D_BOS(YENIKAYIT)
Code (fw): Select all Collapse
  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 (fw): Select all Collapse
  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 (fw): Select all Collapse

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

Page: 1 2 (19 posts)

FiveTech Support Forums

Continue the discussion