Update Query

Description

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

Input Properties

• Input Db Object (IDatabaseObject) – Input opened database connection object.
• Command Type (Dropdown) – 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 (Checkbox) – Closes a connection to a database.

Output Properties

• Result (Int32) – The result of the execution of the UPDATE 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.