DTRHELP.HLB  —  Commands Statements Clauses, MODIFY Statement, Examples
       The following example changes one field value in a selected
       record:

       DTR> READY YACHTS MODIFY
       DTR> FIND FAMILIES WITH FATHER = "JOHN"
       [2 records found]
       DTR> PRINT
       No record selected, printing whole collection.

                             NUMBER    KID
         FATHER     MOTHER    KIDS     NAME    AGE
       JOHN       JULIE         2   ANN        29
                                    JEAN       26
       JOHN       ELLEN         1   CHRISTOPHR  0

       DTR> SELECT 1
       DTR> MODIFY FATHER
       Enter FATHER: JON
       DTR> PRINT

                             NUMBER    KID
         FATHER     MOTHER    KIDS     NAME    AGE

       JON        JULIE         2   ANN        29
                                    JEAN       26

       DTR>

       The following example makes a 10 percent increase in the price of
       the first five yachts. Each yacht begins and ends with a unique
       price, but the new price of each yacht is 10 percent greater than
       the old price of that same yacht.

       DTR> MODIFY FIRST 5 YACHTS USING PRICE = PRICE * 1.1
       DTR> PRINT FIRST 5 YACHTS

                                      LENGTH
                                       OVER
       MANUFACTURER   MODEL     RIG    ALL   WEIGHT BEAM  PRICE

        ALBERG      37 MK II   KETCH   37    20,000  12  $40,646
        ALBIN       79         SLOOP   26     4,200  10  $19,690
        ALBIN       BALLAD     SLOOP   30     7,276  10  $30,250
        ALBIN       VEGA       SLOOP   27     5,070  08  $20,460
        AMERICAN    26         SLOOP   26     4,000  08  $10,885

       DTR>
Close Help