Insert record Version 11 (Java)

Action group: Databases

Description

The action adds the text (string) in the given DB table.

Action icon

Parameters

Input parameters

DB context – connection context to the selected database.
Table name – table name in DB.
Insert data – data in the form of a dictionary for insertion into a table.
List of primary key field names – list of primary key field names to be returned.

Output parameters

As a result we get the list of primary key values generated when inserting data for the field.

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
Insert data	Data in the form of a dictionary for insertion into a table	Robin.Dictionary		Yes
List of primary key field names	List of primary key field names to be returned	Robin.Collection		No
Results
List of primary key values	List of primary key values generated as a result of inserting data for the fields specified in the «List of primary key field names» parameter	Robin.Dictionary

Special conditions of use

None.

Example of use

Task

Connect to the database and insert data in the table (columns AGENT_NAME, WORKING_AREA, COMMISSION, PHONE_NO and COUNTRY) . Data: Lucida, Mumbai, 0.13, 077-12346674, USA.

Solution

Use the "Connect Standard Db", "InsertRecord" actions.

Implementation

Assemble a robot scheme consisting of actions:
Set the parameters for "Connect Standard" action.
Set the parameters for "Insert Record" action.

In the "Insert data" field use data in the form of dictionary.

In the "List of primary key field names" field fill in the following manner:
Click the "Start" button in the top panel.