I have a vision component table on my screen:
This component is directly linked to MySQL table:
SELECT * FROM userprocesses
WHERE processName = '{[default]Internal/ActiveProcessRecipe.value}'
ORDER BY length(layerNumber), layerNumber ASC
I can add and delete rows out of this table, which is directly linked to SQL through a NamedQuery UPDATE on button activation. Once the addition or subtraction of the row, I can click my LOAD button and it performs the above script through a manual poll.
My problem is in regards to all the potential data that is going to be entered into this Ignition table. How can I monitor this, package the new data, and UPDATE MySQL?
This particular example shows 21 layers, but a process is dynamic and may include hundreds of layers. The user may be updating 1 row at a time, or changing them in batches, 3 columns at once, etc.
Can someone point me in the right direction? I'm thinking either a .db.runPrepUpdate or PrepQuery is my command, but I need a way to filter out the edited data, OR a way to examine all the data in the table and just send it as one bulk batch?
Any help is appreciated!