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.
- 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.
- 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.
- Execute a commit statement to make your changes to the table
permanent.