February 18, 2009 at 3:01 am
Hi all.
During the phase of loading a web page that needs to manipulate data i get this message:
View or function '%.*ls' is not updatable because the modification affects multiple base tables
someone can help me?
tks
roberto
February 18, 2009 at 5:02 am
As the error says, the view or function is not updatable because the update command you've issued affects more than one table. An update can only affect a single table.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2009 at 6:46 am
Hi,
thank you for help.
The code i try to manipulate derives from a website generator and acts on view instead tables like i prefer....
r
February 18, 2009 at 1:51 pm
Apparently the view is either non-updatable or you are sending updates to columns that belong to multiple tables.
* Noel
July 9, 2009 at 2:25 pm
I also have the same problem.. My view uses 3 tables... Is there any other way to make the view updateable...
July 10, 2009 at 5:11 am
GilaMonster (2/18/2009)
As the error says, the view or function is not updatable because the update command you've issued affects more than one table. An update can only affect a single table.
True, by default.
If the desire is to allow updates to a view to 'cascade' to the base tables under the view, you will need to create an INSTEAD OF UPDATE trigger on the view, and code the updates to the base tables in that trigger. Not for the inexperienced.
See This MSDN Magazine Article for a comprehensive guide.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply