Editing records

You can also double click on any other column inside the result set after a successful query. This will start the column editmode. You can now perform the usual editing operations on the cell, and once done, press enter to complete the changes. If you have more editing to perform, do so as you like. Once you are done with the changes, press the ‘Update records’ button above the query editor (Default layout). This is run queries to update all the edited record one by one and the result of the operation will be shown to you in the messages pane once the operation is complete.

You can use the checkboxes provided in the second column to delete records, just before the result first column. To select all records for deletion, select the checkbox on the header column. Clicking the ‘Delete record’ button above the query editor will run queries to delete all your selected records. The message pane will be highlighted as usual once the operation completes, showing the number of affected records.