Editing table values from the Interactive SQL result set

From Interactive SQL you can change any or all of the values within existing rows in database tables, provided that 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 to edit the result set.

    A blinking cursor appears in the table cell containing the value.

  4. 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.

  5. 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.

  6. Execute a COMMIT statement to make your changes to the table permanent.

Disabling table editing

You can disable table editing via the Options window in Interactive SQL or via the Interactive SQL initialization file, see Configuring the administration tools.

To disable table editing (Interactive SQL)

  1. From the Tools menu, choose Options, and then choose SQL Anywhere or UltraLite.

  2. Ensure that Scrollable Table is selected and select Disable Editing.

  3. Click OK.

  4. Execute a query.

    You must execute a new query for the changes to table editing to take effect.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0