Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INDEX VIEW + VFP + Update
Message
From
29/04/2005 20:26:46
Keith Payne
Technical Marketing Solutions
Florida, United States
 
 
To
29/04/2005 04:22:11
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
01007348
Message ID:
01009834
Views:
15
>Hi keith,
> I create diffent view for optimization. example I have viewA and (viewB+Index). with both the same source table. I want to use ViewA for update. so I update ViewA still i got an error. Does it means i can no longer use any VIEWS?
>tnx

Sure you can. Just make sure that you are retreiving the primary key(s) for each table in the view that will be updated. Also from SQL BOL:

"The DELETE, INSERT, and UPDATE statements can reference a view as long as SQL Server can translate the user's update request unambiguously to updates in the base tables referenced in the view's definition."
Previous
Reply
Map
View

Click here to load this message in the networking platform