DeleteRecord Version 9 (Java)
Action group: Databases
Description
Deletes records in the specified database table
Action icon
Parameters and their settings
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| DB context | Connection context to the selected database | Robin.DbContext | Database context | Yes |
| Table name | Table name | Robin.String | Yes | |
| Primary key | A 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 fields | Robin.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
- Assemble a robot scheme consisting of actions:
- Set the parameters for the "Connect Standard Db" action.
- Set the parameters for the "DeleteRecord" action.
- In the Primary Key field, specify the key of the row to be deleted.
- 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.
Обзор
Инструменты контента