Need an account? Click to Register
Home arrow Learn arrow Reference arrow Query, TextColumnNames
Query, TextColumnNames
This function assigns the text column captions for each of the text columns loaded from the query.

Syntax:

Query, TextColumnNames, semicolonDelimitedTextColumnNames

Parameters:

semicolonDelimitedTextColumnNames – list of captions for each text column loaded by the query, separated by semicolons.

Examples:

Query,TextColumnNames,Product Line;Product Category

The two text columns loaded by the query are to be labelled ‘Product Line’ and ‘Product Category’.

Comments:

Note that if the SQL query returns fields with names starting with rowlabel_, text_ and numeric_ then the fields will be imported as Row Labels, Text Columns and Numeric Columns respectively, making this function unnecessary.

 
< Prev   Next >

Reference