I am getting the following error message when I try to update a record in a view:
“View or function 'vw_bestel_leverancier_artikel' is not updatable because the modification affects multiple base tables.”
The view is created with a template with a from clause on the table inkoop_advies, with 2 joins to the artikel and leverancier table. Within this view, i want to update a record in a column that refers to inkoop_advies.aantal, which throws the error above.
The table inkoop_advies has only a self reference, which might cause this issue.
I want to be able to edit in grid and change records in the view that refer to inkoop_advies.aantal. I can create a default that updates the correct row, but that will still trigger this error, but change the value nevertheless.
Could an instead of update trigger be the solution? I am not sure how to implement that.
Or can this be solved differently?
Thanks in advance.
Best answer by Mark JongelingView original