ASA Getting Started
Using Interactive SQL
Using Interactive SQL to display data
Editing table values in Interactive SQL
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
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.
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.
Press Tab to move to the next column.
Repeat steps 2 and 3 until all the column values are added.
Press Enter to update the database.
Execute a COMMIT statement to make your changes to the table permanent.
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.