Syntax |
Example |
Description/Remarks |
Q_COL_N |
See sample template for Database Query commands |
Returns a number. Parses the record in the data buffer for the specified connection and returns the numeric value of the nth column. N = 0 to infinity, so you count columns as ‘0, 1, 2…’ (not as ‘1, 2, 3…'). If n > actual number of columns, then Q_COL_N returns "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. |