Problem with Record Lock

[billylo]

Hi,

with SDAC, I can lock a record within a query without any problems. No user can edit it. With UnidDAC, the whole table is locked. You cannot even execute a select on it. Does anybody know how I can lock only one record?

My current code:

Query.LockMode := lmPessimistic;
...
Query.Lock;
Query.RefreshRecord;
Query.Edit;
...

[FCS]

Hello,

Maybe this will be helpful for you:

http://forums.devart.com/viewtopic.php?f=28&t=27371

Regards
Michal

[billylo]

Hi,

unfortunately no help for my problem. When I do so, the whole table is locked an nobody can access it until the lock is over.

[azyk]

We can't reproduce the problem for SQL Server using the code you have provided. Please compose a complete small sample to reproduce the issue and send it to andreyz*devart*com . In addition, include test table creating scripts in the project.