Transaction / Commit mode

By default, Advanced Query Tool operates in auto-commit mode. In this mode, a Commit is done after every SQL statement has been run.

You can change this behaviour by entering transaction mode. With this, your changes are only committed to the database when you explicitly do a commit (or rollback).

These options are controlled by the Transaction menu option on the Run SQL window or Row window.

• selecting Begin Trans will put you into transaction mode.
• selecting Commit Trans will commit your database changes and take you out of transaction mode
• selecting Rollback Trans will roll back (undo) your database changes and take you out of transaction mode

If you are running SQL statements from a file, the commands COMMIT and ROLLBACK will also do a commit / rollback, and keep you in transaction mode (if this was selected).

While you are in transaction mode you can run any statements (including Selects to verify that your changes had the desired effect). You will get a reminder that you have some pending changes.

Warning: by using transaction mode you will be holding locks on rows until you commit. This can lock out other users. You should use this option with caution and never on a production system.

You will not be able to exit Advanced Query Tool until you make a decision to commit / rollback. If the program crashes or is killed then the changes will be rolled back.