Home 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.

 

Reference

Installation - Java