Q_COL_S

Syntax

Example

Description/Remarks

Q_COL_S
connection_number,
n

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 ‘0, 1, 2…’ (not as ‘1, 2, 3…').

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.

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