Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View, Union & Multi-user problem
Message
De
10/10/2000 21:57:55
 
 
À
10/10/2000 21:23:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00427655
Message ID:
00427662
Vues:
12
>I have a view of the form:
>
>Define View AView As ;
> Select FieldA,... From Table1 Where &cWhere1 ;
> Union Select FieldA,... From Table2 Where &cWhere2
>

DEFINE VIEW? You mean CREATE VIEW?

Since views defined with the UNION clause are not updatable, is there any reason that you are using a view for this? You would probably be better served just using a query...
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform