Syntax

This command modifies the specified fields in all rows whose old values satisfy the WHERE condition. The format of the WHERE clause is discussed in section 5.3.1, "SELECT Command." If there is no WHERE clause, all rows are modified.

If the WHERE condition is included, but no rows satisfy the condition, the command does nothing, and it does not report an error.

Example

Enter the following command to change Ellen Smith's city and state to Irvine, California:

If a data source is designated as read-only and the data is linked, users cannot update information in the table or in the data file. Read Only is the default setting. To enable users to update rows in the table and records in the data file, clear the Read Only checkbox on the Advanced tab of the AcuODBC Configuration property sheet (or the AcuODBC Server Configuration property sheet if this is a remote DSN).