SqlStatement
Obsah
Description
Alias: SS
Runs an SQL statement.
Runs an SQL command 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 command.
SQL
Type String
SQL command of the type INSERT, UPDATE or DELETE.
Type Number
Maximum waiting time in seconds for the SQL command to execute.
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.
