DTRHELP.HLB  —  Commands Statements Clauses, SELECT Statement, Examples
       The following example selects the last record in the CURRENT
       collection:

       DTR>  SELECT LAST
       DTR>

       The following example selects the fifth record in the collection
       BIG_ONES:

       DTR>  SELECT 5 BIG_ONES
       DTR>

       The following example selects the last 30-foot boat in the YACHTS
       inventory from the CURRENT collection:

       DTR>  FIND YACHTS
       [113 records found]
       DTR>  SELECT LAST WITH LOA = 30
       DTR>  PRINT

                                      LENGTH
                                       OVER
       MANUFACTURER   MODEL     RIG    ALL   WEIGHT BEAM  PRICE

        SOLNA CORP  SCAMPI     SLOOP   30     6,600  10

       DTR>

       The following example selects a record from the CURRENT
       collection, modifies a field value, and releases the selected
       record and, in this case, the RMS lock on the record:

       DTR>  READY YACHTS SHARED MODIFY
       DTR>  FIND YACHTS WITH BUILDER = "SOLNA CORP"
       [1 record found]
       DTR>  SELECT
       DTR>  PRINT

                                      LENGTH
                                       OVER
       MANUFACTURER   MODEL     RIG    ALL   WEIGHT BEAM  PRICE

        SOLNA CORP  SCAMPI     SLOOP   30     6,600  10

       DTR>  MODIFY PRICE
       Enter PRICE:  50000
       DTR>  PRINT

                                      LENGTH
                                       OVER
       MANUFACTURER   MODEL     RIG    ALL   WEIGHT BEAM  PRICE

        SOLNA CORP  SCAMPI     SLOOP   30     6,600  10  $50,000

       DTR>  SELECT NONE
       DTR>
Close Help