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
rashid

MS Sql Record lock

Post by rashid » Sat 22 Jan 2005 02:03

hi,
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
Top
Ikar
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.
Top
Post Reply

Return to “SQL Server Data Access Components”