In addition AQT has several features to help prevent accidental mass-updates or deletes.
Inline Edit
Use Inline Edit to edit the data directly in the Data Display window. This is a fast way to edit many rows in your table.
This feature also allows you to:
update multiple rows by pasting bulk data into the grid
insert multiple rows by doing a paste-append
preview the update / delete / insert SQL before it is run
An Inline Edit of a table
Row Update
Row Update offers a more flexible method for updating, deleting and inserting rows.
specify which rows you want updated by checking the Where boxes.
specify which columns you want updated by checking the Update boxes.
AQT will generate SQL for the update; you can view the SQL with the Preview SQL button. The SQL can be amended or saved for running later.
This window can also be used for running Inserts and Deletes.
Updating a row using Row Update
Preventing Mass Updates / Deletes
Because AQT allows you to update many rows, even a whole table, it has a number of controls to protect yourself from inadvertently updating or deleting more rows than intended.
before running an Update, you can click on Check Number to see how many rows will be affected by the update.
you can select Transaction to enter Transaction mode. When this is set, your changes are only committed once you explicitly do a Commit (or you can Rollback to discard uncommitted changes). You can run multiple updates, and even view the contents of the table, before deciding whether to commit the change.
AQT has a feature called Safe Update Mode. This gives a warning message if you update/delete more than 1 row. You will be given an option to commit the change or back it out. This applies to any update in AQT (not just through the window shown here). This feature can be configured or switched off.
Safe Update Mode also works when running Updates / Deletes from the SQL window
Safe Update mode can prevent inadvertent mass updates or deletes
