Record has been changed by another user

[jaflores]

I'm working with temporary tables with ON COMMIT PRESERVE ROWS OPTION and TOracleDataSet.. it works fine before the first post, but after that if it is mofified any data I get the following message 'RECORD HAS BEEN CHANGED BY OTHER USER'.

There is not another user working on the table.
No constaints

I'm workink on:
-Delphi 7
-Direct Oracle Access 4.0.3

I don't have any idea what is happening..
any idea?

 

[Marco Kalter]

Perhaps the table has some default values, or there is a before insert/update trigger that modifies column values? In that case you need to include the roAfterUpdate and/or roAfterInsert options in the RefreshOptions property of the dataset. This way the changes made on the server will immediately be visible in the dataset.

 

[jaflores]

TKS This have fixed my problem..