Data.SqlExpr.TTransactionDesc.IsolationLevel
Delphi
IsolationLevel : TTransIsolationLevel; {Transaction Isolation level}
C++
TTransIsolationLevel IsolationLevel;
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| field | public | Data.SqlExpr.pas Data.SqlExpr.hpp |
Data.SqlExpr | TTransactionDesc |
Description
Specifies the isolation level supported by TTransactionItem.
IsolationLevel can take the following values:
| Element | Description |
|---|---|
|
xilDIRTYREAD |
Current transaction sees all changes made by other transactions, even if they have not yet been committed. This option is not available for the Oracle driver. |
|
xilREADCOMMITTED |
Current transaction sees only changes that have been committed, but can receive an inconsistent view of the data if additional changes are committed before the transaction ends. |
|
xilREPEATABLEREAD |
Current transaction is guaranteed a consistent view of the data, which includes only changes committed by other transactions at the start of the transaction. |
|
xilCUSTOM |
Current transaction uses a database-specific isolation level. When the eConnTxnIsoLevel option is xilCUSTOM, the transaction descriptor gives the actual isolation level. This is not currently supported by any drivers, but allows future drivers the ability to expand the number of isolation levels. |