Print

You can use this function to enter new rows of data in tables in the database. To insert data into a table you must first select the table into which data is to be inserted, and then define an insertion template. The insertion template permits you to define the fields in the table for which data will be entered, and also to define simple operations to determine default values for subsequent rows as the data is entered.

Prerequisites: A database is open.

To run this function: Select Database > Edit > Insert records, or Design > Blast design > Edit > Insert records or Survey > Stations > Insert records

• In the Function Chooser, type INSERT TABLE ROW, and press ENTER.

Fields on the Select the database table to process form

Field	Description
Select table	The name of the table to work with.

When you click Apply, the Define insert rows template form is displayed.

This form displays a list of all of the fields in the table for which you can enter values. You can remove a field from the list by right-clicking the left column, and choosing Remove in the shortcut menu. In this form, you can define operators and values to apply to the values on the current rows to create default values for the second and subsequent rows after you add a row in the Insert Table Rows form.

Fields on the Define insert rows template form

Field	Description
Table Name	Read-only. The name of the table you opened.
Field-Name	The name of the field for which you will enter a value.
Operand	The mathematical operator to use to create a default value for the second and subsequent rows of data entry. + The default value for this field is the result of adding the entry in the Value column to the value entered for the previous row. Tip: You can use + or - to increment or decrement (respectively) an alphanumeric field, for example MH01 or 01MH or MH01A, That is, the operand will apply to the numeric part of an alphanumeric value. - Create a default value by subtracting the entry in the Value column from the entry for the previous row. * Create a default value by multiplying the entry from the previous row by the entry in the value column. / Create a default value by dividing the entry from the previous row by the entry in the value column. [blank] Does nothing. The default value for this field is left blank = The default value for this field is made equal to the value from the previous row.
Value	The value that, together with the Operand defines how to increment the default value for second and subsequent rows of data entry.

When you click Apply, the Insert table rows form is displayed. On this form you can enter each new record. Press TAB at the end of a row to add a new row.

Note: Memo fields are limited to 200 characters.

Fields on the Insert table rows form

Field	Description
Table	Read-only. The name of the table you opened.
<fields>	Each field that you allowed to remain in the previous form is displayed.

Output

When you click Apply in the final form, the record or records are added to the database.