SqlStatement/en: Porovnání verzí
(Založena nová stránka s textem „== Output parameters ==“) |
(Založena nová stránka s textem „SQL command of the type INSERT, UPDATE or DELETE.“) |
||
| Řádek 25: | Řádek 25: | ||
Type [[Special:MyLanguage/Data types#String | String]] | Type [[Special:MyLanguage/Data types#String | String]] | ||
| − | SQL | + | SQL command of the type INSERT, UPDATE or DELETE. |
Type [[Special:MyLanguage/Data types#Number | Number]] | Type [[Special:MyLanguage/Data types#Number | Number]] | ||
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
Maximální doba čekání v sekundách na provedení SQL příkazu.
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.