Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View, Union & Multi-user problem
Message
From
10/10/2000 21:57:55
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00427655
Message ID:
00427662
Views:
14
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform