IBDAC

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.

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