Contents Index Editing table values from the Interactive SQL result set Deleting rows from the database using Interactive SQL

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

Inserting rows into the database from the Interactive SQL result set

Interactive SQL also allows you to add new rows to result sets. You tab between columns in the result set to add values to the row. When you add values to the table, characters are stored in the same case as they are entered. You must have INSERT permission on the table to add new rows.

To insert a new row into the result set

  1. Right-click the result set and choose Add from the popup menu.

    A new blank row appears with a blinking cursor in the first value in the row.

    Press Tab to move the cursor from column to column across the row. You can also insert a value by clicking on the value within the selected row.

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

  3. Press Tab to move to the next column.

  4. Repeat steps 2 and 3 until all the column values are added.

  5. Press Enter to update the database.

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

Inserting values into computed columns 

If the result set contains a computed column and you do not specify a value for the computed column, the value is calculated when the database is updated. However, if you specify a value for the computed column, the database is updated with the specified value, and a value is not calculated for the computed column.


Contents Index Editing table values from the Interactive SQL result set Deleting rows from the database using Interactive SQL