Firebird (WIN1252) icon

Firebird (WIN1252)

Get, add and update data in Firebird database (WIN1252 charset support)

Actions3

Update

AI-generated

Summary

Update existing rows in a Firebird database table based on a key column identifying which rows to modify, setting specified columns to new values from the input data.

Inputs

  • Table (required) — Name of the Firebird table in which to update data.
  • Update Key (required) — Column name used to identify rows to update, usually a unique key like 'id'.
  • Columns — Comma-separated list of columns to update in each row.
  • Timeout — Operation timeout in seconds.

Output shape

a list of zero or more JSON objects, typically an empty array signifying success without returning updated records

The operation returns an empty JSON array on success. If errors occur and 'Continue on Fail' is enabled, error messages are returned as JSON items. This operation updates each input item as a separate row update using the update key column.

Examples

Example 1: Update multiple rows in a table by specifying the table, update key column 'id', and columns like 'name' and 'description' to update. Input items contain values for these columns.

Set 'Table' to target table name, 'Update Key' to 'id', and 'Columns' to 'name,description'. Provide input data items with 'id', 'name', and 'description' properties.

Links

Discussion