Home
Query, Command / CommandAppend
This function accepts the SQL command statements. Query,CommandAppend is used to append to the command string over multiple lines.

Syntax:

Query, Command, queryString

Query, CommandAppend, queryString

Parameters:

queryString – the SQL command string, or a “filename.sql” reference

Examples:

query,command,"select order,product,category,2006,2007,forecast" query,commandappend,"from sales_history"

In this example, the SQL query is spread across two lines.

Query,command,”salesforecast.sql”

Loads the SQL query from the file ‘salesforecast.sql’ in the myPagesDir directory as specified by the users variables configuration:

myPagesDir=pages\

Comments:

Note that the commandappend statement adds a space before appending to the previous statement.

If you reference a filename, the file must end with a ‘.sql’ extension.

Be cautious with using prompts delineated with square brackets as some SQL commands also use square brackets to define field names; the prompt string substitution will extend all the way into a referenced .sql command file.

 
< Prev   Next >

Reference