locking multible DB Entries

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 8
Joined: Fri 25 Feb 2005 14:12

locking multible DB Entries

Post by andi_d » Mon 23 Jun 2008 08:52

Using Delphi 5
SDAC Version

Using TMsQuery Component: Is it possible to lock multible DB-Entires an the same time?

If yes - how to do??

Reason: User makes a query on database. Because of special reasons the whole query result should not be changed by another user.

Thanks for helping!


Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Mon 23 Jun 2008 13:57

I can suggest running queries withing a transaction with the appropriate isolation level (e.g. ilIsolated). For more information about isolation levels see the TCustomMSConnection.IsolationLevel topic in SDAC help.

Post Reply