SqlStatement/en: Porovnání verzí
(Založena nová stránka s textem „SQL command of the type INSERT, UPDATE or DELETE.“) |
(Založena nová stránka s textem „Maximum waiting time in seconds for the SQL command to execute.“) |
||
| Řádek 29: | Řádek 29: | ||
Type [[Special:MyLanguage/Data types#Number | Number]] | Type [[Special:MyLanguage/Data types#Number | Number]] | ||
| − | + | Maximum waiting time in seconds for the SQL command to execute. | |
=== Enabled === | === Enabled === | ||
Verze z 31. 1. 2021, 17:22
Obsah
Description
Alias: SS
Executes an SQL command.
Executes 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
Počet řádků ovlivněných SQL příkazem.