Amending individual rows

As well as running action queries, Advanced Query Tool provides two mechanisms for updating/deleting/inserting rows.

Table edit mode

Once you have displayed a table, you can enter Table Edit Mode. In this mode you can amend the table by changing the data in the grid. You can also delete or insert rows.

Row display window

A more comprehensive facility to update data is from within the Row Display window. Use this method if you are doing more complicated changes, such as:

• mass updates / deletes
• setting a column to a system-constant or the value of another column
• loading a LOB value from a file