Data.Win.ADODB.TIsolationLevel
Delphi
TIsolationLevel = (ilUnspecified, ilChaos, ilReadUncommitted, ilBrowse,
ilCursorStability, ilReadCommitted, ilRepeatableRead, ilSerializable,
ilIsolated);
C++
enum DECLSPEC_DENUM TIsolationLevel : unsigned char { ilUnspecified, ilChaos, ilReadUncommitted, ilBrowse, ilCursorStability, ilReadCommitted, ilRepeatableRead, ilSerializable, ilIsolated };
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| enum | public | Data.Win.ADODB.pas Data.Win.ADODB.hpp |
Data.Win.ADODB | Data.Win.ADODB |
Description
TIsolationLevel values specify the level of isolation for a connection.
Use TIsolationLevel values to specify the transaction isolation level for a connection.
Note: it is possible that a server will force an isolation level other than that requested.
The constants that make up the TIsolationLevel type correspond directly to the ADO IsolationLevelEnum values with the same names. These values are discussed in the Microsoft Data Access SDK help, in the topic for the IsolationLevel property of the ADO Connection object. See the SDK for additional information on the ADO constants and their effects.
The constants that make up the TADOLockType type correspond directly to the LockTypeEnum values with similar names and have the same effects. These values are discussed in the Microsoft Data Access SDK help, in the topic for the LockType property of the ADO Recordset object. See the SDK for additional information on the ADO constants and their effects.
TIsolationLevel consists of the nine constants summarized in the following table:
| Isolation Level | Meaning |
|---|---|
|
ilUnspecified |
Server is using an isolation level other than what was requested and the specific isolation level cannot be determined. |
|
ilChaos |
Changes from more highly isolated transactions cannot be overwritten by the current connection. |
|
ilReadUncommitted |
Uncommitted changes in other transactions are visible. |
|
ilBrowse |
Uncommitted changes in other transactions are visible. |
|
ilCursorStability |
Changes from other transactions only visible after being committed. |
|
ilReadCommitted |
Changes from other transactions only visible after being committed. |
|
ilRepeatableRead |
Changes made in other transactions not visible, but requerying can retrieve new recordsets. |
|
ilSerializable |
Transactions conducted in isolation from other transactions. |
|
ilIsolated |
Transactions conducted in isolation from other transactions. |
Note: The constants ilSerializable and ilIsolated have the same effects. These two constants parallel the ADO constants adXactSerializable and adXactIsolated, which have the same effects.