Interactive SQL allows you to add new rows to a table. You tab between columns in the result set to add values to the row. You must have INSERT permission on the table to add new rows.
Right-click the result set and choose Add Row.
A new blank row appears with a blinking cursor in the first value in the row.
Enter the new value and then press Tab to move to the next column.
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.
Repeat this step until all the column values are added.
Press Enter to update the database.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|