Hello,
How can I Update Perspective Table data to SQL Table by using runAction Function in onCellEdit
.
DNice
2
Use the search feature in the forum there are a number of posts related to this already. Here are a few that can help:
1 Like
You have to write a jython script that runs the appropriate SQL UPDATE statement.
That script will be highly specific to your needs. Here are some topic that discuss this (and have samples):
https://forum.inductiveautomation.com/search?q=%20oneditcellcommit%20script%20sql%20order%3Alatest
Keep in mind the values from the table available to you in such a script: