I had a similar problem a few years ago, never found an acceptable solution and programmed a workaround for the most critical situations, which are getting more frequent.
According to the documentation (in
https://docs.devart.com/odac/devart.oda ... ckmode.htm)
Code: Select all
Checking records is useful in creating concurrent multi-user applications. Set CheckMode to specify what action to take when another user makes modifications to a record. TOraDataSet first refetches record values and compares them with those of a client.
I have two applications, AppA opens a record for editing, holds it open, AppB modifies Field1 in the same record, AppA then confirms changes to Field2 in the same record. Now Field1 value changes from AppB are overwritten by the value in AppA, I would expect an exception.
In short, it appears not to work properly.