Devart Forums

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;
...

Hello,

Maybe this will be helpful for you:

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

Regards
Michal

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.

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.