MyDAC

TMyIsolationLevel Enumeration

Specifies the xtent to which all outside transactions interfere with subsequent transactions of current connection.

Unit

MyAccess

Syntax

TMyIsolationLevel = (ilReadCommitted, ilReadUnCommitted, ilRepeatableRead, ilSerializable);

Values

Value Meaning
ilReadCommitted Sets isolation level at which transaction cannot see changes made by outside transactions until they are committed. Only dirty reads (changes made by uncommitted transactions) are eliminated by this state of isolation level. The default value.
ilReadUnCommitted The most unrestricted level of transaction isolation. All types of data access interferences are possible. Mainly used for browsing database and to receive instant data with prospective changes.
ilRepeatableRead Prevents concurrent transactions from modifying data in current uncommitted transaction. This level eliminates dirty reads as well as nonrepeatable reads (repeatable reads of the same data in one transaction before and after outside transactions may have started and committed).
ilSerializable The most restricted level of transaction isolation. Database server isolates data involved in current transaction by putting additional processing on range locks. Used to put aside all undesired effects observed in concurrent accesses to the same set of data, but may lead to a greater latency at times of congested database environment.

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback