Record have been changed by another user

[rdiez]

Hi FORUM!

When I try to edit a record the second time always EDatabaseError reports me with the message 'Record have been changed by another user'.

What's the problem please?

Thanks.

------------------

 

[Marco Kalter]

This probably indicates that the table has some trigger or default column values. When a record is inserted or updated, one or more column values are modified on the server. When you edit it again, the dataset notices that the record in the dataset is different than the record in the database, and raises the exception.

To fix this problem, simply enable the RefreshOptions roAfterInsert and/or roAfterUpdate.

------------------
Marco Kalter
Allround Automations

 

[mesoares]

I have this problem.
I'm using a TOracleDataSet (CacheUpdate = True) and retrive a set os rows. I have a loop in this OracleDataSet, who edit and post each row, in the second row, when I make the ApplyUpdate this error shows (Record has been chanhe by another user).
RefreshOption = [roBeforeEdit,roAfterInsert,roAfterUpdate,roAllFields]
How can I solve this problem ?

 

[Marco Kalter]

What is the table definition(s) and the dataset's SQL?

------------------
Marco Kalter
Allround Automations