Q_COLUMN

Syntax

Example

Description/Remarks

Q_COLUMN connection_number, column_number, "default_value"

See sample template for Database Query commands

This command establishes a default value to be returned if a column value requested by Q_COL_N or Q_COL_S is NULL or if the requested column does not exist.

This command is useful when you don't want to reset the return string"Column n does not exist." to a blank string when reading values that may be NULL.

Connection_number : 1-10. A template may have up to 10 distinct connections to external data sources. A separate data buffer is maintained for each connection.

Column_number : 0 to infinity, so you count columns as ‘0, 1, 2…’ (not as ‘1, 2, 3…').