Devart Forums

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

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.