MS Sql Record lock

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply

MS Sql Record lock

Post by rashid » Sat 22 Jan 2005 02:03

i would like to know how do i lock a record using your component.
this is to ensure 2 users do not edit the same record at the same time.
thanks in advance

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: MS Sql Record lock

Post by Ikar » Mon 24 Jan 2005 10:52

MS SQL Server doesn't provide this functionality.

Using CheckRowVersion property you can check if the record was updated since the last call of Refresh.

Post Reply