SqlStatement/en: Porovnání verzí
| Řádek 29: | Řádek 29: | ||
Type [[Special:MyLanguage/Data types#Number | Number]] | Type [[Special:MyLanguage/Data types#Number | Number]] | ||
| − | + | Timeout in seconds for the SQL statement to run. | |
=== Enabled === | === Enabled === | ||
Verze z 3. 2. 2021, 20:00
Obsah
Description
Alias: SS
Runs an SQL statement.
Runs an SQL statement of the type INSERT, UPDATE, or DELETE stored in the SQL parameter on the data connection specified by the DataConnection parameter. The number of affected records will be stored in RecordsAffected.
Input parameters
DataConnection
Type DataConnection
Data connection to be used for the SQL statement.
SQL
Type String
SQL statement of the type INSERT, UPDATE or DELETE.
Type Number
Timeout in seconds for the SQL statement to run.
Enabled
Type Number
Enables or disables the command. If the value is 0, the command will not execute.
PreWait
Type Number
Delay in milliseconds before executing the command. It has no effect if Enabled=0.
PostWait
Type Number
Delay in milliseconds before executing the command. It has no effect if Enabled=0.
Output parameters
RecordsAffected
Type Number
Number of records affected by the SQL command.
