RDOHELP72.HLB  —  GET  More
    If you have invoked a database, you have the necessary privileges
    to use the GET statement.

    In RDBPRE programs, you can use the GET statement in three ways:

    o  When you establish a record stream with the FOR or START_
       STREAM statement, you use the GET statement to assign values
       from the current record in the stream to variables in your
       program. In the case of START_STREAM, you also need FETCH to
       indicate the current record in the stream.

    o  You can use GET alone, without a FOR or FETCH statement, to
       retrieve the result of a statistical function. The record
       stream is formed by the record selection expression within the
       statistical expression.

    o  Or you can use GET...RDB$DB_KEY in a STORE...END_STORE block
       to retrieve the database key of the record just stored.
       Example:

       &RDB&   STORE E IN EMPLOYEES USING E.EMPLOYEE_ID = 15231;
       &RDB&                              E.LAST_NAME = "Smith";
       &RDB&           GET MY_DB_KEY = E.RDB$DB_KEY;
       &RDB&           END_GET
       &RDB&   END_STORE

       (MY_DB_KEY is a user-defined host language variable.)

    You cannot use the concatenation operation in a GET statement.

                                   NOTE

       Use the GET statement only in RDBPRE programs. RDO uses the
       PRINT statement to display values on the terminal.
Close Help