› Robot building › Robot Steps › Database › Delete From Database

Delete From Database

Use this step to delete a value from the database. To change records in your database, use the Execute SQL step. To extract data from the selected database, use the Query Database step. To store data in the database, use the Store In Database step.

The step verifies that the table it is accessing 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 Delete From Database step stops only when the execution returns to the calling Basic Engine robot, which means that the called Robot might delete multiple values from the database before it stops in the debugger.

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 required type.
Key
Select how to compute the key for the value in the database. If Key Defined in the Type is selected, you must specify the attributes that are marked as Part of Database Key in the Type editor or otherwise the value cannot be found. You can also select Calculated Key and 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.