Editing a row in an Interactive SQL result set

From Interactive SQL you can change any or all the values within existing rows in database tables.

Prérequis

You must have the UPDATE privilege on the columns being modified. For SQL Anywhere and UltraLite databases, table editing must not be disabled.

Contexte et remarques

When you edit a result set, you can only make changes to the values in one row at a time.

Execute a query in Interactive SQL.
On the Results tab, click the value you want to change.
Right-click the value and click Edit Row, or press F2.

A ... button appears in the table cell containing the value.
Click ... and choose one of the following options:
- Edit In Window Opens a window where you can type a new value (character data fields only).
- Set To NULL If the column is not nullable, this menu item does not appear.
- Set To DEFAULT This menu item appears when adding a new row to a table, and only if the column has defined a default value.
- Load From File Lets you browse for a file and then loads the contents of the cell from the file.
Enter the new value. To change other values in the row, press Tab or Shift+Tab to move to the other values.
Press Enter to update the database once you are done editing values in the row.

Press Esc to cancel the change that was made to the selected value.
Execute a COMMIT statement to make your changes to the table permanent.

Résultat

The row in the result set is edited.