hidrau
asked on
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
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
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...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a lot