Skip to main content
Version: 8.1

Update or Insert Group

Inductive University

Update or Insert Group

Watch the video

You can update a row or insert a new row into the database when a key pair combination does not exist. This eliminates the need to have a database that has every possible option considered in its original design. Because of the insert row when not present setting, the group will insert a new record whenever the designated ID doesn't exist. Afterwards, it will update the rows in the table that are associated with the key/value references as shown in this example.

Update or Insert a New Row into the Database

  1. In the Project Browser, right-click on Transaction Groups and select New Standard Group.

    Update or Insert a New Row into the Database Step 1

  2. Give the group a name and click Create Group.

  3. Drag a group of tags into the groups Basic OPC/Group Items section.

    Update or Insert a New Row into the Database Step 3

  4. Change one of the tags to be read-only by selecting Read Only from the tag's Target Name column.

    Update or Insert a New Row into the Database Step 4

  5. In the group's Action tab, in the Table action area, select the update/select radio button and the key/value pairs radio button.

    Update or Insert a New Row into the Database Step 5

  6. Click the Add (Add Icon) icon.

    1. For the Column, select the database table ID column.
    2. For the Value column, select the read-only tag.
    3. Select Insert row when not present check box at the bottom of the Table action area.
  7. Select the group, and click Enabled.

  8. Save the project to start the group.