How do I update multiple tables in a view 1

[janwills]

I am unable to update a view in sqlserver. I get the following message.


Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]View or function 'dbo.VIEW_Milestones' is not updatable because the modification affects multiple base tables

Help.....

 

[wrbodine]

You can create a "INSTEAD OF UPDATE" trigger on the view, that will fire off when the update statement is called. See Books Online under "INSTEAD OF UPDATE" for more info.

This is the way you update a view that uses more than one table with SQL 2000. You must make sure the "WITH CHECK OPTION" isn't selected, since this doesn't allow view updates.

Good luck,
Ray

 

[janwills]

THANK YOU!! I'll give a try.