Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Administering your database » SQL Anywhere graphical administration tools » Using Interactive SQL » Editing result sets in Interactive SQL

 

Inserting rows into the database from the Interactive SQL result set

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.

 To insert a new row into the result set
  1. 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.

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

  3. Press Enter to update the database.

 Inserting values into columns with default values
 Inserting values into computed columns
 Inserting new rows using the INPUT statement
 See also