I’m using FSQL 4.2.11 to write back set point in a PLC by selecting a specific Block id. FactorySQL seems to be made for that but I can’t find a way to do it.
I have more than a thousand of value so I’m using block group. I have one block group “OPC to DB” running each hour to get the data and one block group “DB to OPC” writing the value when a trigger is activate. With that, I want to write back value from a specific date in the PLC. I’m using a stored procedure in Microsoft SQLserver to find in the table all the values from the selected date and time. This stored procedure is call by an action item in the “DB to OPC” group. I supposed that what is writting in the PLC is the part of the table selected by the stored procedure. Am I wrong?
My problem is…it’s seems that thing don’t go as I planned! I can’t see what I’m doing wrong because at no point I have an error message but nothing is written in the PLC. Do I have to use the Stored Procedure block instead of calling one with an action item? Do I have to first create a table with the selected data and then write it in the PLC? And most important, am I clear in my explanations?
Thanks in advance for your help.