Pathmaker Programming Guide

Inserting Rows
How to Operate a DB Requester Application
067868 Tandem Computers Incorporated B–9
INSERT BOX
(Shifted F10)
To insert several rows from one box at a time, the end user must request an INSERT
BOX operation. Before requesting the INSERT BOX operation, values must be entered
in the required columns of at least one repetition. When the application successfully
completes the INSERT BOX operation, it displays a message indicating the number of
rows inserted.
For applications that access Enscribe files, if the application encounters an error during
an INSERT BOX operation, it highlights the fields of the record in error. The
application displays the following prompt on the screen:
Continue processing, Y/N, F1
If the application displays this prompt, the end user must enter either the character Y
(to continue) or the character N (to stop) and then press F1. If the end user enters a Y,
the application continues the INSERT BOX operation beginning with the record
directly following the record in error. If an N is entered, the application stops the
INSERT BOX operation. In this case, the application has already inserted any records
that preceded the record in error.
For applications that access NonStop SQL tables, if an error is encountered during an
INSERT BOX operation, all columns in error are highlighted and the application
displays the message associated with the first column in error in the message area.
The application will insert all rows that are error free.
The effects of an INSERT BOX operation can be reversed by requesting an UNDO
(shifted F13) operation immediately after the INSERT BOX operation.
INSERT BOX Operation
Several rows can be inserted using one INSERT BOX operation by doing the following:
1. Entering appropriate values in the columns of the rows.
2. Pressing shifted F10 to insert the rows.
Figure B-2 illustrates a sample INSERT BOX operation for an application that displays
several rows in a single box. It is not necessary to enter values for every row position.