When a query is based on a single table and there is sufficient key information, the result set can be edited from within the result area. To edit a result set click the Edit button at the bottom of the window. If the Edit button is not active, your result set is not editable. (Under Linux this button is labeled Start Editing.)

Once in edit mode you can insert, update, and delete rows from the result set. Navigate the fields using the Tab and arrow keys, and press Enter to edit the content of a field. You can also double-click a field to make it editable. When editing a field, use the tab key to move to the next editable field. All edited fields are highlighted in blue for easy identification.

To add rows to the result set, scroll to the blank row at the bottom of the result area and fill in the fields. All new rows are highlighted in green.

To delete a row right-click on the row and choose the Delete Row option. All deleted rows are highlighted in red.

Changes made to the result set are not applied immediately, but instead are cached until the Apply Changes button is pressed. You can abort your edits with the Discard Changes button. Exiting edit mode without choosing to apply or discard your changes prompts you to apply or discard your work.