Run Command

Object that allows the user to run commands in the database

Settings

Field

Description

Title

Object title

Object Identifier Name

Window Automation Unique Name (variable)

Select the main Object

Represents the settings of the database

Alter/Selection

Define the action to be taken

Command

Command that should be run on the database

Example

In order to run commands in a database, some steps must be taken:

1 - Select the database configuration object. In this example we will use Sql Server.

  • First of all drag into the working area the object SQL Server;

  • Next, add the Run Command object and set the Sql Server configured earlier as the configuration object;

  • Set the type of operation to be performed. In this case the object separates in two ways of execution.

    • Execution of Insert, Alter or Delete script (other commands can also be executed);

    • Execution of script for data loading (SELECT).

  • Enter the command and click on "Confirm".

Important: How to loop through the returned data when the command type is "Select"?

Every data selection command will return a LIST with the columns that were requested. In order to loop through the data, it will be necessary to include the object "Loop Through List" in the working area, which can be found in the "Loops" menu.

Workin Area

The working area for this example should be like:

r

The "LOG Message" object included within the "Loop Through List" exemplifies how information can be accessed. In this case, we access the "Description" column of the "TbClient" table.

Last updated

Was this helpful?