question

Billy-4342 avatar image
0 Votes"
Billy-4342 asked SeeyaXi-msft commented

Updating multiple tables

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?

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

`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...

0 Votes 0 ·

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

0 Votes 0 ·

1 Answer

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.