Update modes

[Atys]

Hi,

I would like to ask, what is the proper way to detect if the current record has been changed by another
user before posting back to the db?

[azyk]

To solve the specified issue, you can set the TUniQuery.LockMode property to lmPessimistic. If between dataset opening and the Edit method call the current record is changed by another user - UniDAC will generate the error message 'Record was changed by another user'.

[Atys]

Thank you