Am using a software called M-Files and when i try to INSERT to multiple tables using a view i get an error that says view not updatable because it affects multiple base tables. Is there a way to resolve this issue?
Am using a software called M-Files and when i try to INSERT to multiple tables using a view i get an error that says view not updatable because it affects multiple base tables. Is there a way to resolve this issue?
`Would this be an SQL Server database, you could write an INSTEAD OF trigger. I have never heard of M-Files, so I don't know if it is related to SQL Server or not. But since you post to an SQL Server tag, maybe it is...
Hi @Billy-4342 ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Hi @Billy-4342,
Please have a look at this: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15
if you want to insert into views in other way you can refer this article: https://www.codeproject.com/Articles/236425/How-to-insert-data-using-SQL-Views-created-using-m
From this part, you can see some information about INSTEAD OF trigger.
Best regards,
Seeya
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
15 people are following this question.