oralcal modify error

[hitman]

this is mic ado

UPDATE "LIU1" SET "OPCODE"=:V0001 WHERE "OPCODE"=:V0002 AND "ROWID"=:V0003

this is zeoxlib

UPDATE LIU1 SET GOODSID=:P1 WHERE GOODSID=:P2 AND OPCODE=:P3 AND GOODSNAME IS NULL AND GOODSENGNAME IS NULL AND GOODSINVNAME IS NULL AND GOODSSHORTNAME IS NULL AND GOODSFORMALNAME IS NULL AND GOODSFORMALPY IS NULL AND GOODSTYPE IS NULL AND GOODSPINYIN IS NULL AND GOODSUNIT IS NULL AND PACKNAME IS NULL AND CREDATE IS NULL AND LASTSALESDATE IS NULL AND INPUTMANID IS NULL AND FIRSTAPPROVEDOCNO IS NULL AND APPROVEDOCNO IS NULL AND GOODSNO IS NULL AND SPECIALNO IS NULL AND STANDARDNO IS NULL AND STANDARDTYPE IS NULL AND VALIDPERIOD IS NULL AND OLDGOODSID IS NULL AND TRADEMARK IS NULL AND FACTID IS NULL AND PERIODUNIT IS NULL AND PRODAREA IS NULL AND SUPPLYTAXRATE IS NULL AND SALESTAXRATE IS NULL AND FIXPRICETYPE IS NULL AND CLASSID IS NULL AND VARIETYID IS NULL AND VARTYPEID IS NULL AND ACCFLAG IS NULL AND DEFAULTAGTFLAG IS NULL AND SALESGRADE IS NULL AND STORAGECONDITION IS NULL AND TRANSCONDITION IS NULL AND MEMO IS NULL AND USESTATUS IS NULL AND RESPPERIOD IS NULL AND VARIETYUNITQ

if the table no prikey and there is many row have same value

when i change a row in datagird

all of row changed it is bug i am chinease english so pool

[pol]

What do you think it should behave? If the SQL hits many rows it will update many rows, it has nothing to do with zeos.
Why is there no primary key? It would make things much easier, and you would not have such a huge where clause.

[hitman]

thank's

[zippo]

Primary key - it should be necessary.

Then just update by the primary key.