Update Perspective Table data to SQL Table

Hello,

How can I Update Perspective Table data to SQL Table by using runAction Function in onCellEdit
.

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: