XL3RunSQL2

Revision as of 08:11, 26 April 2022 by Csalter (talk | contribs) (Parameters)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Available in V10.0.128+, allows a SQL Statement to be run when required (used in conjunction with XL3Link to trigger the execution)

Syntax

XL3RunSQL2( ExcecuteSQL, Connection, Datasource, SQLStatement, @p1, @p2, ....,@p27)

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.
Connection The connection to use to connect to the database. Can only be Connection ID of a workbook relational connection.
Datasource Connection specific information, generally not needed and can be left blank
SQLStatement The SQL statement to run
[@p1..@p27] Optional - Parameters passed to the SQL, reference the parameters using @p1,@p2 in the SQL Statement. Strings will automatically get escaped with apostrophes

Examples

XL3RunSql2(J3,1,"","Insert into test(value) select @p1",L4)

When J3 is set to TRUE (via an XL3Link) then the SQL statement is run using the connection 1 passing the parameter in L4. After completion J3 will be reset to FALSE - ready for the next update by an XL3Link. Note that to use this on XLCubed Web Edition, the XL3Link should be of type 3 (HyperLink with submit changes on web).

See Also