IBTransaction Editor dialog box

Go Up to Database Dialog Boxes

The Transaction Editor dialog box allows you to set up transaction parameters. This dialog box gives you four default transaction settings, which you can then customize if you wish. Once you modify the default transaction, the radio button is unset.

For a complete list of all the InterBase transaction parameters, refer to 'Working with Transactions' in the InterBase API Guide.

These properties of the transaction component, as well as others, can also be specified using the Object inspector.

To display the Transaction Editor dialog box, double click on an IBTransaction component. The following four choices are displayed:

Snapshot

By default, Snapshot is set to concurrency and no wait, which means that the transaction is aware of other transactions, and does not wait for locks to be released, returning an error instead.

Read Committed

By default, Read Committed is set to read_committed, rec_version, and no wait, which means that the transaction reads changes made by concurrent transactions, can read the most recently committed version of a transaction, and does not wait for locks to be released, returning an error instead.

Read-Only Table Stability

By default, Read-Only Table Stability is set to read and consistency, which means that the transaction can read a specified table and locks out other transactions.

Read-Write Table Stability

By default, Read-Write Table Stability is set to write and consistency, which means that the transaction can read and write to a specified table and locks out other transactions.

For a complete list of all the InterBase transaction parameters, refer to 'Working with Transactions' in the InterBase API Guide.