Update Data

AQT provides two ways to update data:

  • Inline edit
  • Row update

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