Store In Database

Use this step to store data from a variable in a database. This step works similarly to the Store In Database step in the Basic Engine Robot. To change records in your database, use the Execute SQL step. To extract data from the selected database, use the Query Database step.

The step verifies that the table it is writing to matches the definition of the type and configuration, and produces an error if any of these do not match. A warning is also displayed while editing the Robot, as long as the database can be reached. In this case, you can right-click the step and select (Re)create Table in Database to open a SQL dialog box, which helps you update the table from Design Studio.

When in debug mode and Values are Returned or Stored is selected under Stop When, the robot that uses the Store In Database step stops only when the execution returns to the calling Basic Engine robot, which means that the called Robot might store multiple values in a database before it stops in the debugger.

You can add this step directly from the Robot workflow or from the State pane by right-clicking a type and clicking Insert Step > Store In Database.

Properties

Database Mapping
Select a database mapping from the databases specified in the Call Robot step.
Variable
Select a variable to read the value from. This variable must be of a complex type.
Key
Select how to compute the key for the value in the database. If you select Key Defined in the Type, the attributes that are marked as Part of Database Key in the Type editor are used to compute the key. Otherwise, when you select Calculated Key, specify an expression to compute the key.
Audit Data

If selected, the Audit data fields are included with the value. For more information, see Store Data in Databases. This step is compatible with the Store In Database step in Basic Engine Robots only as long as Audit Data is selected.