Is there any way to treat Lock record in table with clientdataset?
Hello guys
I have a table and two users request the record at the same time.
When the first user gets the record, the second should must get a message about the record is locked.
How should I do that with clientdataset?
thanks
Alex
Delphi
Last Comment
hidrau
8/22/2022 - Mon
Sinisa Vuk
This is more complex than you think. Please look at Optimistic concurrency control idea... Probably, you need additional field in a table... With Lock function set some value if empty (like username) and on Unlock - clear field... Assess row if username is equal...