DTRHELP.HLB  —  Commands Statements Clauses, SELECT Statement, Arguments
    FIRST

       Selects the first record in the target collection.

    NEXT

       Selects the next record in the target collection. (See the second
       and third items in the Results section.) When you omit a position
       specification, NEXT is the default.

    PRIOR

       Selects the previous record in the target collection. (See the
       fifth and sixth items in the Results section.)

    LAST

       Selects the last record in the target collection.

    value-expression

       Evaluates to a positive number. DEC DATATRIEVE uses the integer
       part of the number to select the record with that position number
       in the collection.

    NONE

       Releases the selected record so that no selected record exists
       for the current collection. If the collection was formed from a
       file-structured database, SELECT NONE also releases the RMS lock
       on the selected record.

    collection-name

       Is the name of the target collection containing the record to be
       selected. If you omit the collection name, the target collection
       is the current collection.

    WITH boolean

       Causes DEC DATATRIEVE to select the record that satisfies both
       the Boolean expression and the collection position references
       (FIRST, LAST, NEXT, PRIOR, and value-expression).
Close Help