DeleteRecord Version 9 (Java)

Action group: Databases

Description

Deletes records in the specified database table

Action icon

Parameters and their settings

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
DB contextConnection context to the selected databaseRobin.DbContextDatabase contextYes
Table nameTable nameRobin.String
Yes
Primary keyA field or combination of fields that uniquely identifies the record to be deleted. Specified as a dictionary, where key-value pairs are the names of the primary key columns and the contents of their fieldsRobin.Dictionary
Yes

Special conditions of use

None.

Example of use 

Task

Connect to the database and delete the record in the table with ID=9 .

Solution

Use actions "Connect Standard Db", "DeleteRecord". 

Implementation

  1. Assemble a robot scheme consisting of actions:
  2. Set the parameters for the "Connect Standard Db" action. 
  3. Set the parameters for the "DeleteRecord" action. 
  4. In the Primary Key field, specify the key of the row to be deleted. 
  5. Click on the "Start" button in the top panel. 

Result

The program robot completed successfully.


The record with ID=9 has been deleted from the database.