Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can the From clause of a view be modified at run time?
Message
From
20/12/2007 22:20:51
Craig Berntson
Quicken Loans
Salt Lake City, Utah, United States
 
 
To
20/12/2007 20:18:21
Jeff Hibbs
The Blencowe Group
Columbia, South Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Can the From clause of a view be modified at run time?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01276935
Message ID:
01276940
Views:
23
Just USE theTable ALIAS theAlias
then create the view to reference theAlias. Each table will be opened using the same alias.

>I would like to create one view to access multiple tables with the same structure. The only difference in these tables is the last two characters of the name.
>
>Thanks in advance
>
>Jeff Hibbs
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform