HELPLIB.HLB  —  RDML72  Statements  STORE Statement
    Inserts a record into an existing relation. You can add a
    record to only one relation with a single STORE statement.
    The statements between the keywords STORE and END_STORE form a
    context block. You cannot store records into views defined by any
    of the following record selection expression (RSE) clauses:

    o  WITH

    o  CROSS

    o  REDUCED

    o  FIRST

    Trying to store into views that were defined with any of the
    above clauses could cause unexpected results in your database.

    You can use the GET statement within the bounds of the STORE ...
    END_STORE block. Note that any valid format of the GET statement
    is permitted within this block.

    You may find it particularly useful to use the GET statement to
    place the database key (dbkey) of the record you are storing into
    a host variable. Use the GET...RDB$DB_KEY construct to assign the
    value of the dbkey to the host variable.
Additional Information: explode extract
Examples Format
Close Help