SQL Guide : solidDB® SQL statements : UPDATE
  
UPDATE
UPDATE table_name
  SET [table_name.]column_identifier = {expression | NULL}
  [, [table_name.]column_identifier = {expression | NULL}]...
  [WHERE search_condition]
UPDATE table_name
  SET [table_name.]column_identifier = {expression | NULL}
  [, [table_name.]column_identifier = {expression | NULL}]...
  WHERE CURRENT OF cursor_name
Usage
There are two types of UPDATE statements:
The searched UPDATE statement, UDPATE table_name ... [WHERE search_condition], modifies the values of one or more columns in one or more rows specified with search_condition.
The positioned UPDATE statement, UPDATE table_name ... WHERE CURRENT OF cursor_name, updates the current row of the cursor. The name of the cursor is defined using ODBC API function named SQLSetCursorName.
table_name can be a table name or an alias.
Example of searched UPDATE
UPDATE TEST SET C = 0.44 WHERE ID = 5
Example of positioned UPDATE
UPDATE TEST SET C = 0.33 WHERE CURRENT OF MYCURSOR
See also
solidDB® SQL statements