Recipe DB to OPC Transaction

Ignition
, ,
1

I am working on testing a Transaction Group using DB to OPC for recipe Data stored in a database. I am trying to figure out how to use a memory tag to trigger the ID of the row of data I want for that recipe and then write back to the desired tags. NewStackConfig is the tag I am trying to use, not for sure how to tie it to the StackConfigID.

Capture
Capture1437×673 79.9 KB

2

Move NewStackConfig to the “Run Always” section. Then you can select it as your trigger.

3

I have it move to Run-Always but how do I tie it to the StackConfigID column?

4

You have to include it in the WHERE clause you put under the update/select radio button.

5

I figured it out alittle bit after I posted that, been working on the database. Thanks for the help