Syntax
UPDATE table SET column-assignments [WHERE <predicate-list
| CURRENT> [<ON / OF> [CURSOR] cursor]] [WITH options]
UPDATE
Required.
table
Required. The name of the table containing the data to be
updated
column-assignments.
column-assignments
Required. A comma separated list of column name/new value
pairs. (column-name = new-value, ...)
WHERE predicate-list | CURRENT
Optional. Provide a predicate-list to qualify specific rows
to be updated or update only the CURRENT row. Caution! If
omitted, ALL rows will be updated with the new values.
predicate-list - Criteria to determine which rows will be
updated.
CURRENT - Update only the current row.
[ON [CURSOR] cursor]
Optional. The cursor on which to perform the delete. If omitted,
the delete will be performed on the current cursor.
[WITH options]
Optional. A comma separated list of options to use when performing
the update.
top
OdxSQL Example
top
|