I Insert New Row

This command allows you to create a new row in the table. The row is created with all the fields initialized appropriately — to the initial value, spaces, zeroes or the current date, depending on the field type — ready for input of new data.

It is also possible to create a new row from each of the tablesONLINE Edit Table screens by entering INSERT on the command line. This will create an empty row that can then be completed.

The new row will be placed in the table according to key sequence. If the key is a duplicate of an existing key, the new row will be placed before the row containing the matching key. If you are editing a User Ordered or Random table or editing a View, the new row will be placed in the table, or View, one position below the currently selected row. In a user ordered table, if you wish to indicate a specific position for the new row you can insert NEW, followed by the desired row location, on the command line (for example, NEW 10 will create a new row and place it in the tenth position in the table.)

If the Protect Keys Indicator is set to Y in the View, this operation will fail since this indicator prevents the creation of new rows. If the Duplicate Keys Allowed Indicator in the View is set to N, or if the Duplicate Keys Allowed Indicator on the Identify Table/Row screen has been set to N, then any edit operation that would create a row with a key matching an existing row will fail.