SqlStatement/en: Porovnání verzí
(Založena nová stránka s textem „Data connection to be used for the SQL command.“) |
|||
| (Není zobrazeno 20 mezilehlých verzí od stejného uživatele.) | |||
| Řádek 7: | Řádek 7: | ||
'''Alias: SS''' | '''Alias: SS''' | ||
| − | ''' | + | '''Runs an SQL statement.''' |
| − | + | Runs an SQL statement of the type INSERT, UPDATE, or DELETE stored in the [[#sql-|SQL]] parameter on the data connection specified by the [[#dataconnection-|DataConnection]] parameter. The number of affected records will be stored in [[#recordsaffected-|RecordsAffected]]. | |
== Input parameters == | == Input parameters == | ||
| Řádek 18: | Řádek 18: | ||
Type [[Special:MyLanguage/Data types#DataConnection | DataConnection]] | Type [[Special:MyLanguage/Data types#DataConnection | DataConnection]] | ||
| − | Data connection to be used for the SQL | + | Data connection to be used for the SQL statement. |
<span id="sql-"></span> | <span id="sql-"></span> | ||
=== SQL === | === SQL === | ||
| − | + | Type [[Special:MyLanguage/Data types#String | String]] | |
| − | SQL | + | SQL statement of the type INSERT, UPDATE or DELETE. |
| − | + | Type [[Special:MyLanguage/Data types#Number | Number]] | |
| − | |||
| − | + | Timeout in seconds for the SQL statement to run. | |
=== Enabled === | === Enabled === | ||
| − | + | Type [[Special:MyLanguage/Data types#Number | Number]] | |
| − | + | Enables or disables the command. If the value is 0, the command will not execute. | |
=== PreWait === | === PreWait === | ||
| − | + | Type [[Special:MyLanguage/Data types#Number | Number]] | |
| − | + | Delay in milliseconds before executing the command. It has no effect if Enabled=0. | |
=== PostWait === | === PostWait === | ||
| − | + | Type [[Special:MyLanguage/Data types#Number | Number]] | |
| − | + | Delay in milliseconds before executing the command. It has no effect if Enabled=0. | |
| − | == | + | == Output parameters == |
<span id="recordsaffected-"></span> | <span id="recordsaffected-"></span> | ||
=== RecordsAffected === | === RecordsAffected === | ||
| − | + | Type [[Special:MyLanguage/Data types#Number | Number]] | |
| − | + | Number of records affected by the SQL statement. | |
Aktuální 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 statement.
