A transaction is executed entirely by using the StartTransaction, Commit, and Rollback methods of the TEDBDatabase component. A typical transaction block of code looks like this:

begin
   with MyDatabase do
      begin
      StartTransaction(EmptyEDBStringsArray);
      try
         { Perform some updates to the table(s) in this database }
         Commit;
      except
         Rollback;
      end;
      end;
end;

The EmptyEDBStringsArray variable is defined in the edbtype unit (Delphi or Lazarus) or edbtype header file (C++) in ElevateDB.


Restricted Transactions

---

It is also possible with ElevateDB to start a restricted transaction. A restricted transaction is one that specifies only certain tables be part of the transaction. The StartTransaction method accepts an optional array of tables that can be used to specify what tables should be involved in the transaction and, subsequently, locked as part of the transaction (see below regarding locking). If this list of tables is nil (the default), then the transaction will encompass the entire database.

The following example shows how to use a restricted transaction on two tables, the Customer and Orders table:

var
   Tables: TEDBStringsArray;
begin
   with MyDatabase do
      begin
      SetLength(Tables,2);
      Tables[0]:='Customer';
      Tables[1]:='Orders';
      StartTransaction(Tables);
      try
         { Perform some updates to the table(s) in the transaction }
         Commit;
      except
         Rollback;
         raise;
      end;
      end;
end;

For more information on transactions in ElevateDB, please see the Transactions topic.