| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3QueryTableSetSQL"
| Line 28: | Line 28: | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
* [[Query Tables]] | * [[Query Tables]] | ||
| + | * [[Relational Data Tables]] | ||
[[Category:Formulae]] | [[Category:Formulae]] | ||
[[Category:Query Table Formulae]] | [[Category:Query Table Formulae]] | ||
[[Category:Relational Reporting]] | [[Category:Relational Reporting]] | ||
Revision as of 16:38, 19 March 2012
 |
XLCubed now includes a updated version of this feature, more information about which can be found in this article. |
Sets the SQL statement of a Query Table.
Syntax
XL3QueryTableSetSQL( SheetName, QueryTableName, SQL )
Parameters
| Parameter | Description |
|---|---|
| SheetName | Name of the worksheet where the Query Table is located |
| QueryTableName | Name of the Query Table |
| SQL | The new SQL statement to use |
