Syntax |
Example |
Description/Remarks |
Q_COL_S |
See sample template for Database Query commands |
Parses the record in the data buffer and returns the nth column as a string value. N = 0 to infinity, so you count columns as Problem: If a column value is a number, and you use the formula Q_COL_S n * 10, it won’ t multiply the number by 10, because the Q_COL_S return value is a string. Use Q_COL_N instead. If n > actual number of columns, then return "Column n does not exist" or the default value set by the Q_COLUMN command in an earlier cell. 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. |