Transactions
Go Up to Using InterBase Databases
A transaction is a group of actions that must all be carried out successfully on one or more tables in a database before they are committed (made permanent). If any of the actions in the group fails, then all actions are rolled back (undone).
Client applications can start multiple simultaneous transactions. InterBase provides full and explicit transaction control for starting, committing, and rolling back transactions. The statements and functions that control starting a transaction also control transaction behavior.
InterBase transactions can be isolated from changes made by other concurrent transactions. For the life of these transactions, the database appears to be unchanged except for the changes made by the transaction. Records deleted by another transaction exist, newly stored records do not appear to exist, and updated records remain in the original state.
For details on using transactions in database applications, see Using Transactions. For details on using transactions in multi-tiered applications, see Creating Multi-tiered Applications in the Delphi Developer’s Guide. For more information about transactions refer to Understanding InterBase Transactions.