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