Execute one or more SQL statements.
ExecuteSQLTransaction is no longer supported.
| Overload Name | Description |
|---|---|
| General | Execute one or more SQL statements. |
Execute one or more SQL statements.
| 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
|
| Driver | The driver to use. |
| ServletPath | The servlet-path to use. |
| SQLConnectString | The SQL connect-string to use. |
| Username | The username to use. |
| Password | The password to use. |
| Statements | One or more SQL statements delimited with the specified delimiter. |
| StatementDelimiter | The delimiter to use to define the end of each statement. The default is the "|" (pipe) character. |
| Inserts | One or more SQL statements delimited with the specified delimiter. The insert statements are executed if the corresponding statement fails. The number of insert statements must be zero or the same number as the number of Statements. |