A query string for an UPDATE.
| TableName | Name of table to make update query string for. |
| SetDict | Dict containing column names and values to set in the update. |
| WhereDict | Optional. Dict containing column names and values to select what to update. |
Note that for the dicts, you (currently) must put quotes around any values that will go into text columns or receive an error. We may add support in a future release for automatically detecting the column type and quoting values as necessary.
For information regarding exceptions / errors, see
here.
% SqlUpdateStatement my_table {intvalue 1} {realvalue 1.1}
UPDATE my_table SET intvalue = 1 WHERE realvalue = 1.1