TIBCIsolationLevel Enumeration

Specifies the transaction isolation level and access mode.

Unit

IBCClasses

Syntax

TIBCIsolationLevel = (iblSnapshot, iblReadCommitted, iblReadOnlyReadCommitted, iblTableStability, iblReadOnlyTableStability, iblCustom);

Values

Value	Meaning
iblCustom	The parameters of the transaction are set manually in the Params property.
iblReadCommitted	Enables the transaction to see all committed data in the database, and to update rows updated and committed by other simultaneous transactions without causing lost update problems.
iblReadOnlyReadCommitted	Enables the transaction to see all committed data in the database with read-only access mode.
iblReadOnlyTableStability	Provides a transaction read-only access to the tables it uses. Other simultaneous transactions may be able to select rows from these tables, but they can not insert, update, and delete rows from these tables.
iblSnapshot	The default isolation level. Provides a stable, committed view of the database at the time the transaction starts. Other simultaneous transactions can UPDATE and INSERT rows, but this transaction cannot see these changes. For updated rows, this transaction sees versions of these rows as they existed at the start of the transaction. If this transaction attempts to update or delete rows changed by another transaction, an update conflict is reported.
iblTableStability	Provides a transaction sole insert, update, and delete access to the tables it uses. Other simultaneous transactions may still be able to select rows from these tables.