+---------------------------------+
|             UPDATE              |
+---------------------------------+
UPDATE ON <key field>
        FROM <expN> | <expC>
        REPLACE <field1> WITH <expr1>
        [, <field2> WITH <expr2> ... ]
        [RANDOM]

-----------------------------------
Updates a database with information from another database.
-----------------------------------

<key field>
        A common field in the selected database and the database file you
update from that controls the updates.  The selected database must be
indexed or sorted in ascending order on <key field>. UPDATE performance
is improved if the update database is also sorted or indexed.

FROM <expN> | <expC>
        The work area number <expN> or the alias <expC> of the database in
another work area that the selected database is updated FROM.

REPLACE <field1> WITH <expr1> ...
        <field1> is a field in the selected database that will have its
contents replaced with <expr1>.  To update more than one field in the
selected database, include an optional list of fields (<field2>,
<field3> ... ) and corresponding update expressions (<expr2>, <expr3>
... ).

        If each record in the selected database has multiple matching records
in the update database, the record in the selected database is updated
by each of these matching records.

        If there are identical key field records in the selected database, only
the first of these matching records is updated.

RANDOM
        If the update database isn't indexed or sorted in ascending order, you
must include RANDOM.  Otherwise, the desired number of records may not
be updated.

-----------------------------------

See Also:  INDEX, JOIN, SORT

-----------------------------------