Working with Transactions

If you have come to InterBase from working with desktop databases like Paradox, dBase and Access then the use of transactions can be confusing.

Desktop systems use record locking strategies to prevent a user from updating a particular record that is being (or has been) updated by another user. Dealing with locks can be very complicated and confusing in anything but the simplest of databases. This is especially true if there are multiple changes that you want to make and you want all the changes to get through or none of them. These are the sorts of things that transactions provide quite easily.

Hopefully the following topics will be of some assistance when using transactions with IBO...

   Transaction Basics
   Is a Transaction In Progress?
   Closing a Transaction
   AutoCommit and StartTransaction
   Transaction Isolation
   Transaction Pausing