DTRHELP.HLB  —  Commands Statements Clauses, PRINT Statements, Examples
       The following example retrieves data from selected records and
       prints the data:

       DTR> FIND FIRST 2 YACHTS
       DTR> SELECT; PRINT TYPE, LOA, PRICE

                               LENGTH
                                OVER
       MANUFACTURER   MODEL     ALL    PRICE

        ALBERG      37 MK II    37    $36,951

       The following example shows how to retrieve data from target
       streams formed by FOR loops:

       DTR> FOR FIRST 2 YACHTS
       CON> PRINT TYPE, LOA, PRICE

                               LENGTH
                                OVER
       MANUFACTURER   MODEL     ALL    PRICE

        ALBERG      37 MK II    37    $36,951
        ALBIN       79          26    $17,900

       DTR>

       The following example shows how to retrieve data from
       hierarchical records using nested FOR loops:

       DTR> FOR FIRST 2 FAMILIES
       CON> FOR KIDS
       CON> PRINT MOTHER, FATHER, KID_NAME

                                KID
         MOTHER     FATHER      NAME

       ANN        JIM        URSULA
       ANN        JIM        RALPH
       LOUISE     JIM        ANNE
       LOUISE     JIM        JIM
       LOUISE     JIM        ELLEN
       LOUISE     JIM        DAVID
       LOUISE     JIM        ROBERT

       DTR>
Close Help