Inserting Rows into the Database from the Interactive SQL Result Set

The Insert command adds a new blank row to the database table. Use the Tab key to move 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. See insert in Reference Manual: Commands.

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

    A new blank row appears in the result set 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 appropriate field in the selected row.

  2. Enter the new value.

    You cannot enter invalid datatypes into a column. For example, you cannot enter a string into a column that accepts the int datatype.

  3. Execute a commit statement to make your changes to the table permanent.