En

Execute Query#

Execute an INSERT, UPDATE, DELETE query to the database.

Connection String[Text] Connection string to the database. The string is specified according to the selected provider. When using an already open connection, do not set this property, but specify a variable with the current connection object in the "Connection Reference" property.
User[Text] Username for authentication.
Password[Text/SecureString] Password for authentication.
SQL ProviderSelect SQL provider.
Connection Reference[Link] SQL connection object. The name of the variable in this property must match the name of the variable in the "Connection Reference" property of the "Connect" block from the Databases group that was previously used to connect to SQL.
Query

[Text] Query string. The string is written according to SQL language rules.

For example, "INSERT INTO sometable (column1) VALUES ('value1')"

Input Parameters[Dictionary] Input parameters. The dictionary must contain key values as parameter names without the @ symbol. The values of the dictionary are the parameter values. By default, the parameter type is NVarChar(MAX).
Timeout[Number] Timeout for query execution in seconds.
Result[Number] If an INSERT query is executed, the auto-increment index of the inserted row is returned.
Error Handling Level

Select error handling level. Possible values:

  • "Default" - default;
  • "Ignore" - errors are ignored;
  • "Handle" - errors are handled.

If "Default" is selected, the value from the "Start" block of this diagram will be used.

Message Level

Select the message level that blocks will output during operation. Possible values:

  • "Default" - default;
  • "Release" - output is disabled;
  • "Debug" - main information output;
  • "Detailed" - detailed information output.

If "Default" is selected, the value from the "Start" block of this diagram will be used.

Error Text[Text] Returns detailed information about the error in case of incorrect execution of the block.