AQT offers an alternate method for updating, deleting and inserting rows.
In the Row Display window, use Update Mode to build an Update/Delete/Insert SQL statement that you then run. This gives you more control than the inline edit and an easier update of multiple rows.
- specify the table row to update by checking a Where box in the Update grid.
- specify the table column (or field) to update by checking an Update box in the Update grid.
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.
AQT has a number of features to help you with updates: for example, the Get Values button (RHS in the screenshot below) adds a drop-down list of existing values for the grid cell that has the focus.