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…'). |