SQL and PMI questions

Archived Topics
8

I think the easiest thing to do is literally use static where clauses such as:

machine_num=1

and

machine_num=26

The column “machine_num” does NOT have to be anywhere in your group. When you start the group, FactorySQL will ask if you want to create the column, if it doesn’t exist. Next, factorysql will ask to create a row that matches that condition. After that, it will only ever write to that row, and it won’t matter if the OPC connection is up or down.

Hope that helps,