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>