locking multible DB Entries

andi_d · Post by **andi_d** » Mon 23 Jun 2008 08:52

Using Delphi 5
SDAC Version 4.50.0.35

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!

Andi

Antaeus · 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.