I think I already know the answer to this question but thought I would ask the GURU’s here.
I have an action item which is writes to a table in Microsoft SQL. This action item is in a group which is triggered and the trigger is set to ‘Change of state’. So with that my questions are:
The action item that writes to the SQL table will only write to the SQL table if the state of the trigger has changed. Would this be correct?
If the action item has stuck in the on position, you see it is set up that on the first pass it sets the action item to a 1 then on the second pass it sets it to a 0 (zero), kind of follows the trigger, but occasionally it sticks in the on position. Anyway if the action item is stuck on but the trigger has not changed then the value of the action item is not written to the SQL table. Would this be correct?
So if this action item sets the SQL table, but the action item has not reset, and the trigger has not occured, the value that was written by the action item stays in the SQL table. And if this value in the table is sent to the PLC units on the production floor and then I have the PLC clear this, the value in the table will change, so long as I have the correct data setting in FSQL, but it will not show the change in the action item. Would this be correct?
Thanks and have a great day.