Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INDEX VIEW + VFP + Update
Message
De
29/04/2005 20:26:46
Keith Payne
Technical Marketing Solutions
Floride, États-Unis
 
 
À
29/04/2005 04:22:11
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
01007348
Message ID:
01009834
Vues:
14
>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."
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform