The update block can be used to update one or many existing rows.
Select the database table or array of complex types you wish to update, use the + button on the left to add column values you will be updating, and build a where clause to filter which rows you will be updating.
Only writeable data structures can be updated with the Update block at runtime.
- Database tables
- Arrays of complex types
Structures which cannot be updated with this block include local tables. To edit a local table, you must either edit it design time as an administrator, or connect it to a database table. Learn more about local tables.