Search

User Manual

GETTING STARTED


MODULES AND PLATFORM


APPENDIX


TUTORIALS & HELPFUL TRICKS


GLOSSARY


STRATEGIC PARTNER LINKS

Sepasoft - MES Modules
Cirrus Link - MQTT Modules

RESOURCES

Inductive University
Ignition Demo Project
Knowledge Base Articles
Forum
IA Support
SDK Documentation
SDK Examples

ALL USER MANUAL VERSIONS

Ignition 8.1
Ignition 7.9
Ignition 7.8

Deprecated Pages

Employees

Sign In

Skip to end of metadata
Go to start of metadata


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.


IULocgo


Update or Insert Group

Update or Insert a New Row into the Database

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

     

  2. Give the group a name and click Create Group.
  3. Drag a group of Tags into the groups Basic OPC/Group Items section.



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


     
  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.



  6. Click the Add  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.


Next...


  • No labels