We are currently evaluating FSQL and I need some design assistance for what I am trying to accomplish.
We have a VB.net application that we are using in conjuction with FSQL and a PLC for production line control. We have given the operators to change certain timing values in the PLC via the VB application. When they change the values in the VB application, those values are written back to a SQL database using an update statement.
The question I have is…how do I write those values down to the PLC, ONLY when they have changed in the SQL database? I attempted to use the Expression language but didn’t get very far. I know what I want to do, but I am not sure how to get from Point A to Point B.
As a side note, the SQL table houses other settings that has nothing to do with the PLC, so I need to select specific values from the table and “map” them to my OPC values to be written down to the PLC. Sorry for the long explanation.
Any help would be greatly appreciated.