Executes a delimited list of SQL statements within a single server request. IMPORTANT: If the Statements argument contains a semicolon ";", then multiple statements should be delimited using a non-semicolon character, such as the pipe character "|", which should be specified as the StatementDelimiter argument. By default, the StatementDelimiter is a semicolon.
| Overload Name | Description |
|---|---|
| General | Executes a delimited list of SQL statements within a single server request. |
Executes a delimited list of SQL statements within a single server request.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| SQLConnectionID | The SQL connection ID used by the operation. |
| Statements | The SQL statements delimited by the StatementDelimiter. |
| StatementDelimiter | The character used to delimit the statements. The recommended delimiters include the pipe "|" and the semi-colon ";". By default, a semi-colon is assumed to be the delimiter, but if any of statements include a delimiter, a non-semicolon character, such as the pipe character "|", should be used and specified as the StatementDelimiter. |
| Transaction |
Controls whether the statements are executed within a transaction. By default, a transaction is not opened.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ContinueOnError |
If the Transaction argument is FALSE, ContinueOnError controls whether the remaining statements are executed when a given statement generates an error. By default, execution of the remaining statements is not continued when an error is encountered.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| BackgroundExecute | Controls whether the operation is executed asynchronous. |
| CoverDuringExecute |
Controls whether the view is covered while the statements are executed. By default, the view is not covered.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ProgressTextStarted | (Optional) The text string displayed as the progress text in the status bar before the statements are executed. If no value is specified, "SQLPassthroughExecute started" is displayed as the progress text. |
| ProgressTextCompleted | (Optional) The text string displayed as the progress text in the status bar after the statements are executed. If no value is specified, "SQLPassthroughExecute completed" is displayed as the progress text. |
| ResultPropertyName | (Optional) The name of the workbook script property that receives the value of the result, which is a string containing the result of each statement delimited by the StatementDelimiter. |
| ErrorPropertyName | (Optional) The name of the workbook script property that receives the error message if the service returns an exception. |