Devart Forums

1. CREATE TABLE TEST(ID number, OLD_ID number);

2.
DataSet.Update;
DataSet.FieldByName('ID').AsInteger := 10;
DataSet.FieldByName('OLD_ID').AsInteger := 20;
DataSet.Post;

Act: ODAC (6.10) generates statement like:

UPDATE TEST
SET
ID = :ID, OLD_ID = :OLD_ID
WHERE
ID = :OLD_ID

Exp:

UPDATE TEST
SET
ID = :ID, OLD_ID = :OLD_ID
WHERE
ID = :_ID


P.S. This issue exists in any case of OLD_ like named field

P.S.S. DELETE statement also still affected

You should set the KeyFields property to 'ROWID' or manually write the SQLUpdate and SQLDelete statements.

Plash wrote:You should set the KeyFields property to 'ROWID' or manually write the SQLUpdate and SQLDelete statements.

You think i`m so stupid? Really? :\

Doubt answer.. no more. Thank`s for "support". Now I`m has one more argument - ODAC are bad choice for us. Thanks.