| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3SqlArea"
(Created page with "Creates and updates table range based on the results of a SQL Query. ==Syntax== {{Code|XL3SqlArea( RunQuery, SendUpdates Connection, OutputRange, Sql)}} ==Parameters== {| ...") |
(→Examples) |
||
| Line 31: | Line 31: | ||
When B3 is set to TRUE (via an XL3Link) then the SQL statement in A1 is run and the result of the query is outputted to the cell B4. After completion B3 will be reset to FALSE – ready for the next updated by an XL3Link. | When B3 is set to TRUE (via an XL3Link) then the SQL statement in A1 is run and the result of the query is outputted to the cell B4. After completion B3 will be reset to FALSE – ready for the next updated by an XL3Link. | ||
| − | |||
| − | |||
| − | |||
==See Also== | ==See Also== | ||
Revision as of 15:30, 22 June 2015
Creates and updates table range based on the results of a SQL Query.
Contents
[hide]Syntax
XL3SqlArea( RunQuery, SendUpdates Connection, OutputRange, Sql)
Parameters
| Parameter | Description |
|---|---|
| RunQuery | A cell reference that contains TRUE when the SQL Statement should be run. After execution the cell reference will be set to FALSE or an error message if an error occurred. |
| SendUpdates | The connection to use to connect to the database. This can either be the Connection ID of a workbook relational connection or a connection string. |
| Connection | The SQL statement to run |
| OutputRange | Optional - Worksheet name containing query table to refresh after the SQL has run |
| Sql | Optional - The name of the query table to refresh after the SQL has run |
Examples
XL3SqlArea(B3,1,B4,A1)
When B3 is set to TRUE (via an XL3Link) then the SQL statement in A1 is run and the result of the query is outputted to the cell B4. After completion B3 will be reset to FALSE – ready for the next updated by an XL3Link.
