Select Query

Description

This action component allows you to execute a query on a database and returns the query result in a Datatable.

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 (DataTable) – Stores the output of the SQL command in a DataTable 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.