Difference between revisions of "XL3QueryTableSetSQL"
(Created page with 'Sets the SQL statement of a Query Table. ==Syntax== {{Code|XL3QueryTableSetSQL( SheetName, QueryTableName, SQL )}} ==Parameters== {| class="wikitable" ! Parameter ! Descriptio…') |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
(3 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
+ | {{Imbox | ||
+ | | type = notice | ||
+ | | text = FluenceXL now includes a updated version of this feature, more information about which can be found [[Relational Data Tables|in this article]]. | ||
+ | |}} | ||
+ | |||
Sets the SQL statement of a Query Table. | Sets the SQL statement of a Query Table. | ||
Line 23: | 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 (Version 6)]] |
Latest revision as of 09:52, 4 July 2023
![]() |
FluenceXL 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 |