Insert Query

Description

This action component allows you to execute a non-query Insert statement on a database.

Input Properties

• Input Db Object (IDatabaseObject) -Input opened database connection object.
• Command Type (CommandType) -Specifies how the CommandText property is to be interpreted.
• Timeout (Int32) -Specifies the amount of time (in millisecond) to wait for the sql command to run.
• SQL Text (String) -SQL command to be executed.
• Parameters (String) -A dictionary of named parameters that are bound to the SQL command.
• Disconnect (Boolean) -Closes a connection to a database.

Output Properties

• Result (Int32) – The result of the execution of the INSERT SQL command. The number of rows affected as Int 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.