Update Perspective Table data to SQL Table

[Nishant_Tambe]

Hello,

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

[DNice]

Use the search feature in the forum there are a number of posts related to this already. Here are a few that can help:

SQL update table

Hi, I have a data set pulled into ignition tag that updates every 24hrs( I don’t have permission to access that DB and this is the only way I can get that dataset). I would like to save the dataset into my DB and update it every 24hrs to reflect the changes that occurred in the last 24 hrs, what would be the best way to do such thing? I was thinking maybe a procedure that will delete the old table and write the new data, perhaps there is a better way? Oh the reason I want that data in my DB i…

Needs to update perspective table using SQL query through scripting

One customised table was designed for some functions. That table data property is bound to an SQL query so that the SQL data can be monitored in the table itself. Now I want to update the SQL data from the table by selecting the table row. I have attached the file for your reference. As per my design, once I select any row in the table, the selected row’s data will show in the text field. Once I made some changes to the existing data, I needed to press the update button to update the table data.…

[pturmel]

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:

Perspective - Table Scripting | Ignition User Manual