Progress
Language Reference


INSERT Statement

Interfaces
OS
SpeedScript
All
All
No

Creates a new database record, displays the initial values for the fields in the record, prompts for values of those fields, and assigns those values to the record.

The INSERT statement is a combination of the following statements:

DATA MOVEMENT

  1. CREATE: Creates an empty record buffer.
  2. DISPLAY: Moves the contents of the record buffer to the screen buffer and displays the screen buffer.
  3. PROMPT-FOR: Accepts input from the user into the screen buffer.
  4. ASSIGN: Moves the contents of the screen buffer to the record buffer.

SYNTAX

INSERT record [ EXCEPT field ... ] 
  [ USING { ROWID ( nrow ) | RECID ( nrec ) } ]
  [ frame-phrase ] 
  [ NO-ERROR ] 

record

The name of the record you want to add to a database file. Progress creates one record buffer for every file you use in a procedure. This buffer is used to hold a single record from the file associated with the buffer. Use the DEFINE BUFFER statement to create additional buffers, if necessary. The CREATE part of the INSERT statement creates an empty record buffer for the file in which you are inserting a record.

To insert a record in a file defined for multiple databases, you must qualify the record’s filename with the database name. See the Record Phrase reference entry for more information.

EXCEPT field

Inserts all fields except those listed in the EXCEPT phrase.

USING { ROWID ( nrow ) | RECID ( nrec ) }

Allows you to insert a record in an RMS relative file (for backward compatibility only) using a specific record number, where nrow is the ROWID relative record number of the record you want to insert and nrec is the RECID relative record number of the record you want to insert.

frame-phrase

Specifies the overall layout and processing properties of a frame. For more information on frame-phrase, see the Frame Phrase reference entry.

NO-ERROR

Specifies that any errors that occur when you try to insert the record are suppressed. After the INSERT statement completes, you can check the ERROR-STATUS system handle for information on errors that have occurred.

EXAMPLE

In this procedure the user adds a new order record. After the user adds a new order record, the procedure creates order-lines for that record. The procedure uses the CREATE statement to create order-lines rather than the INSERT statement. When you use the INSERT statement, the PROMPT-FOR and ASSIGN parts of the INSERT let you put data into all the fields of the record being inserted. In the case of order-lines, this procedure only lets you add information into a few of the order-line fields. Use CREATE together with UPDATE to single out the order-line fields.

r-insrt.p
REPEAT:
  INSERT order WITH 1 COLUMN.
  REPEAT:
    CREATE order-line.
    order-line.order-num = order.order-num.
    UPDATE line-num order-line.item-num qty price.
    /* Verify the item-num by finding an item
      with that number */
    FIND item OF order-line.
  END.
END. 

NOTES

SEE ALSO

DEFINE BUFFER Statement, Frame Phrase


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095