En

Insert Data Table#

Inserts a data table into the specified table in the database.

Connection String[Text] The 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] The username for authentication.
Password[Text/SecureString] The password for authentication.
SQL ProviderSelect the SQL provider.
Connection Reference[Link] The SQL connection object. The variable name in this property must match the variable name in the "Connection Reference" property of the "Connect" block from the Databases group that was previously used to connect to SQL.
Data Table[Data Table] The data table that will be inserted into the table. The column names of the data table must match the names from the database table.
Table Name[Text] The name of the table into which the data should be inserted.
Exclude Columns[Number/Text] The column number or a string with column numbers separated by commas. The specified columns will not be used in the query. Numbering starts from zero.
Timeout[Number] The timeout for executing the query in seconds.
Result[Number] Returns the number of inserted records.
Error Handling Level

Select the 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 the blocks will output during operation. Possible values:

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

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's work.