Run Command
Object that allows the user to run commands in the database
Last updated
Object that allows the user to run commands in the database
Last updated
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 |
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.
The working area for this example should be like:
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.
