I have a table component in vision and I have used named queries to get the values from database and update in vision table
I am able to add values in the respective vision table but it is not reflecting in the database
Can you please me out with this issue?
You need to somehow trigger an update to the database. Depending on your needs there are several ways to accomplish that.
Are you using the standard Table component or the Power Table component?
Probably the easiest way to accomplish this is the following (assuming you're using the standard table), is to add a
cellEdited script to the table. You can either use the
SQL Update tab or you can use the
Script Editor tab and call
system.db.runNamedQuery() to run an update query against the database.
Just to clarify what @lrose is saying: Ignition doesn't edit database tables for you. If you edit a table in your UI, you are responsible for updating the database with appropriate SQL. Ignition provides events that you can react to in order to do so.
You can also wait until all edits are done, and use a "save" button to go through your edited table content and push the changes to the DB. (Usually need to keep an unmodified copy of the dataset handy for comparison.)
This is the script which I have written for adding a new record in the table
It is not updating in the database and once I close and open the project, the record will be deleted
Thanks everyone! Appreciate it!