Record was changed by user ...

[smww]

Hi all - first post to forum,

Curious issue that is causing me some problems. When a user edits record and saves it for the second time the following message appears, "Record was changed by another user".

This issue is common for most clients, except one. That user can edit/save same record multiple times with no message. They are all using the same version of the program.

I am using UNIDAC version 4.6.12 on Delphi 2010. All users are using O/S Win 7.

Any suggestions appreciated
S.

[DemetrionQ]

Hello.

    To solve the problem, check the TUniTable.LockMode property. If it is set to lmOptimistic or lmPessimistic, then, when attempting to update a record modified by another user, behaviour will be the same as you got. To modify the behaviour, set the TUniTable.LockMode proeprty to lmNone.
The detailed information about LockMode can be read in the UniDAC documentation.

[RNOVAK]

Hello smww

See on MySQL database if the field has trigger or default value when your app sets to null. Maybe one trigger changes the field or the default value rewrites your null value.

Roberto

[m227]

Hi, would you clarify what specific TLockMode values do? It is not specified in my UniDac documentation...

[ViktorV]

Please note that you can find a well-detailed description of TLockMode at https://docs.devart.com/unidac/devart.dac.tlockmode.htm