Hi I have a perspective table component which is bound to a named query that fetches data from SQL database.
Is there any way to make the Perspective table component editable to alter the data of the table which will also update the SQL database table directly.
Yes. If you create the column records in the properties of the table you can make the cells editable.
Then, when the cell is edited you can trigger a named query to update the database for that record. Or you can wait for all the cells to be edited and have a button to update all changed records.
No, the component cannot do this for you. You must script the handling of edited data to produce/execute the necessary SQL UPDATE ... statement, and then refresh the query binding to show the result in your UI.