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.
Record was changed by user ...
-
- Devart Team
- Posts: 271
- Joined: Wed 23 Jan 2013 11:21
Re: Record was changed by user ...
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.
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.
Re: Record was changed by user ...
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
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
Re: Record was changed by user ...
Hi, would you clarify what specific TLockMode values do? It is not specified in my UniDac documentation...
Re: Record was changed by user ...
Please note that you can find a well-detailed description of TLockMode at https://docs.devart.com/unidac/devart.dac.tlockmode.htm