Firebird (WIN1252) icon

Firebird (WIN1252)

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

Actions3

Insert

AI-generated

Summary

Insert multiple new rows into a specified Firebird database table by providing the table name and comma-separated column names. Each input item supplies values for these columns, which are inserted in a single batch operation.

Inputs

  • Table (required) — Name of the table in which to insert data to.
  • Columns — Comma-separated list of the columns to be inserted with the corresponding values from each input item.
  • Timeout — Timeout in seconds for the insert operation, defaulting to 10.

Output shape

a list of JSON objects representing the insert operation result for each batch; typically an empty object or insert metadata.

All input items are inserted in a single batch within one SQL INSERT query. If the operation fails and 'Continue On Fail' is enabled, error details are returned as JSON objects; otherwise, the node errors. The inserted data encoding respects the WIN1252 charset configured on the node credentials.

Links

Discussion