SharpenDB UPDATEDataSharpensharpenDbUpdate· Version 1.0.0
Run an UPDATE query on a table in SharpenDB.
Modifies existing rows in a SharpenDB table. Set the fields and new values to write — values can use $(name) variables — and restrict which rows change with Where conditions. An update is refused, and takes invalidInput with the reason, when it has no condition, when a condition's value is blank (IS NULL, IS NOT NULL, IS TRUE, and IS NOT TRUE need none), or when a condition matches every row: a LIKE pattern of only %, or a NOT IN list holding an empty value. The flow takes default when the update succeeds. A query SharpenDB does not answer within 20 seconds takes timeout, or fallback when timeout is not wired. The node's Timeout field is not applied: it does not change that 20-second limit.
Integration required
Fields
| Field | Type | Required | Description |
|---|---|---|---|
Tabletable | dynamicDropdown | Required | The table to update. |
Update fieldsfields | dynamic array of fields with options | Required | Set fields to update with values |
Wherewhere | dynamic array of fields with options | Required | WHERE conditions to filter which rows to update. Each condition compares a table field using an operator against a value. |
Where OperatorwhereConditionOperator | string | Optional | What operator (AND/OR) to use for the where condition. |
Variablesvariables | array of objects | Optional | Save variables from the data returned. |
Timeouttimeout | number | Optional | Not applied yet: SharpenDB queries always wait up to 20 seconds, whatever this is set to. |
Exits
System exits (auto-injected, hidden when unwired): invalidInput, fallback.