How to get the record locked status in .net

  • Thread starter Thread starter Joy
  • Start date Start date
J

Joy

Hello:

After I start a transaction with "REPEATABLE READ", before I commit, if I
begin another transaction to the same records, how can I get the locked
status of these records?

Thanks.
 
Query with sp_lock? I would look at the source code of this system sp and
see what it's doing to inspect the current locks.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Yes, you are right, ADO.NET uses optimistic concurrency by default.

Please let me clarify my question here:
I am using advantage data provider in my .NET project to access DBF database
files. I want to lock the records when I start my transaction, and I want to
get the record lock status, so that I can display the locked record only
view.

But I do not know how to realize this .

Thanks.
 
Back
Top