aspnetguy Posted May 30, 2006 Share Posted May 30, 2006 Is it possible after a view is created to insert into that view and have it update the related tables??? Or must I update the related tables seperately to have the new records show in the view? Link to comment Share on other sites More sharing options...
aspnetguy Posted May 30, 2006 Author Share Posted May 30, 2006 Nevermind, I figured it out. Link to comment Share on other sites More sharing options...
Raj Ali Posted September 20, 2006 Share Posted September 20, 2006 Nevermind, I figured it out.If ur view is based on a single table than it is possible to update o insert into it.Likeinsert into<view_name>values(<column1value>,<column2value>........)update <view_name> set column_name=required condition where column_name=conditionand if view is based on the data which comes from multiple tables than it is not possible to update or insert into it. Link to comment Share on other sites More sharing options...
aspnetguy Posted September 20, 2006 Author Share Posted September 20, 2006 Thanks, I had figured that out Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now