Firebird (WIN1252) icon

Firebird (WIN1252)

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

Actions3

Execute Query

AI-generated

Summary

Execute a parameterized SQL query on a Firebird database using WIN1252 encoding and retrieve the result set.

Inputs

  • Query (required) — The SQL query to execute, which can include named parameters prefixed with ':'.
  • Parameters — Comma-separated list of named parameters used in the query; values for these parameters should be taken from the previous node's output.
  • Timeout — Timeout in seconds for the query execution; minimum is 1, default is 10.

Output shape

a JSON array where each element represents a row returned by the query, decoded using WIN1252 charset; or a JSON object with error information if the query fails and 'Continue On Fail' is enabled.

The node processes each input item independently, substituting named parameters with values from the corresponding input item's JSON. If no parameters are defined or used, the query is executed as-is. Execution errors throw unless 'Continue On Fail' is enabled, in which case error details are returned as JSON.

Examples

Example 1: Executing a query with parameters

Provide a SQL query with named parameters (e.g. :param1, :param2), list the parameters as comma-separated values matching input JSON keys, and the node substitutes these from each input item, executes the query, and returns the result rows as JSON.

Links

Discussion