Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Administering your database » SQL Anywhere graphical administration tools » Using Interactive SQL » Editing result sets in Interactive SQL


Editing table values from the Interactive SQL result set

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

have UPDATE permission on the columns being modified. In addition, for SQL Anywhere and UltraLite databases, table editing must not be disabled.

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

 To edit a row in the result set
  1. Execute a query in Interactive SQL.

  2. On the Results tab, click the value you want to change.

  3. Right-click the value and choose Edit Row, or press F2.

    A ... button appears in the table cell containing the value.

  4. Click ... and choose one of the following options:

    • Edit In Window   Opens a window in which you can type in a new value (applies only to character data fields).

    • Set To NULL   Sets the cell value to NULL. If the column is not nullable, this menu item does not appear.

    • Set To DEFAULT   Sets the cell value 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   Opens a file browser for you to enter a file name, then loads the contents of the cell from the file.

  5. Enter the new value. If you want to change other values in the row, press Tab or Shift+Tab to move to the other values.

  6. Press Enter to update the database once you are done editing values in the row.

    You can press the Esc key to cancel the change that was made to the selected value.

  7. Execute a COMMIT statement to make your changes to the table permanent. For example press CTRL+SHIFT+C.

 Enabling and disabling table editing