Q_COL_N

Syntax

Example

Description/Remarks

Q_COL_N
connection_number,
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.

Sets text buffer for use with FIELD, COL_N, and COL_S.