ASA Getting Started
  Using Interactive SQL
    Using Interactive SQL to display data
      Editing table values in Interactive SQL

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. You must have UPDATE permission on the columns being modified. 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. Click the value you want to change.

2. Right-click the result set and choose Edit from the popup menu. You can also press F2 to edit the result set.

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

3. Enter the new value.

   You cannot enter invalid data types into a column. For example, you cannot enter a string into a column that accepts the INT data type.

   If you are done editing values in the row, press Enter to update the database. If you want to change other values in the row, press Tab or Shift+Tab to move to the other values.

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

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

Editing computed columns 

Once you edit values in the result set, the database is updated with the modified values. Computed columns are recalculated based on the modified values whether or not they are part of the result set. However, if there are computed columns in your result set, and you modify a value in the computed column, the database is updated with the modified value.