Link to home
Start Free TrialLog in
Avatar of hidrau
hidrauFlag for Brazil

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
Avatar of Sinisa Vuk
Sinisa Vuk
Flag of Croatia image

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
Avatar of Geert G
Geert G
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hidrau

ASKER

Thanks a lot