Hello,

before we started using UniDAC we have used the Direct Oracle Access components (DOA) from AllroundAutomations.

The dataset of  DOA has a nice feature regarding CachedUpdates.

Before it applies any changes to the database in ApplyUpdates, it reads back for each changed row the data of the original row from the database and compares the values to the stored oldValues. Only if the values compare equal, the update is done, otherwise it throws an exception "Record has changed by another user".

An example:

- User A opens a record from a table with cachedupdates

- User B opens the same record

- User B changes the record and applies the updates to the database

- User A changes his local record

- User A applies his updates

  

Without the checking feature of DOA, User A does not recognizes that his record has been changed by User B before he applies his changes. The changes of User B get overwritten.

With this checking the User A looses his changes and must start over. 

For our application that is what we want to have.

Maybe you can think about this feature?

Best regards

Joachim