If the database you are using supports transactions, where transactions can be started, committed, and canceled or rolled back, you can also use this feature within InfoNaut. For more information on transactions and rollbacks in CONNX, see "Record Locking and Transactions"in the CONNX User Reference Guide.  Note: Transactions are disabled for connections that contain at least one database that does not support transactions.

 

1.  Create a query with data from databases that support transactions.

2.  Click the Begin transaction button.

3. The transaction is started and all subsequent data modifications are contained in this transaction.

4.  To commit the transaction, click the Commit transaction button.

5.  All modifications in the transaction are committed to the database.