Writes new values to existing row(s) in a table
Format
UPDATE Table
SET update-element [ , update-element ]*
[ WHERE bool-condition ]
Remarks
NOTICE
UNEXPECTED BEHAVIOR OF APPLICATION
Be aware that this command will include Group Templates if they exist in the database and are matched by the WHERE clause. Take care to exclude Group Templates when using the command to update values in Group Instances.
Likewise, take care to exclude Group Instances when using the command to update values in Group Templates.
Failure to follow these instructions can result in unexpected or incomplete configuration changes.
The searched UPDATE command writes new values to row(s) in a database table. The operation is multi-row in that it can update zero or more rows in a single operation.
The optional WHERE clause defines a condition which selects which rows will be updated. If the WHERE clause is omitted, all rows in the table will be updated.
Example:
UPDATE CPointDigitalManual
SET CurrentState = 1
WHERE FullName = 'Test Point'