Insert Datatable

Description

This action component allows you to insert a DataTable variable in an existing database Table.

Input Properties

• Input Db Object (IDatabaseObject) -Input opened database connection object.
• Table Name (String) -The SQL table in which the data is to be inserted.
• Input DataTable (DataTable) -The DataTable variable that will be inserted into the Database Table.
• Timeout (Int32) -Specifies the amount of time (in millisecond) to wait for the SQL command to run.
• Disconnect (Boolean) -Closes a connection to a database.

Output Properties

• Result (Int32) – Returns the number of affected rows, as a Int32 variable.

General Properties

• GlobalWaits (Checkbox) – Apply global waits when PreWait or PostWait are not specified.
• IgnoreError (Checkbox) – Continue the process flow without throwing error.
• PostWait (Checkbox) – Apply specified wait after execute the action.
• PreWait (Checkbox) – Apply specified wait before execute the action.