Difference between revisions of "XL3RunSQL"
| Line 22: | Line 22: | ||
==Examples== | ==Examples== | ||
| − | {{Code| =XL3RunSql(J3,CommentData!$G$1,L3)}} | + | {{Code|==XL3RunSql(J3,CommentData!$G$1,L3)}} |
''When J3 is set to TRUE (via an [[XL3Link]] then the SQL statement in L3 is run using the connection string specified in CommentData!G1. After completion J3 will be reset to FALSE - ready for the next update by an XL3Link'' | ''When J3 is set to TRUE (via an [[XL3Link]] then the SQL statement in L3 is run using the connection string specified in CommentData!G1. After completion J3 will be reset to FALSE - ready for the next update by an XL3Link'' | ||
Revision as of 11:52, 31 August 2011
Allows a SQL Statement to be run when required (used in conjunction with XL3Link to trigger the execution)
Contents
[hide]Syntax
XL3RunSQL( ExcecuteSQL, ConnectionString, SQLStatement)
Parameters
| Parameter | Description |
|---|---|
| ExecuteSQL | 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. |
| ConnectionString | The connection string to use when running the writeback |
| SQLStatement | The SQL statement to run |
Examples
When J3 is set to TRUE (via an XL3Link then the SQL statement in L3 is run using the connection string specified in CommentData!G1. After completion J3 will be reset to FALSE - ready for the next update by an XL3Link
