Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copying a view from one database to another
Message
 
To
28/05/2001 12:39:24
Dave Nantais
Light speed database solutions
Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00511943
Message ID:
00511956
Views:
16
>Using Stonefield Database toolkit I can copy and paste a view from one database into another. Unfortunately a client has 'legacy data' not using Stonefield.
>Is there any way to copy and paste views between databases in regular VFP?

Besides what Cetin said... You can use Erik Moore's Eview product (available in the files section) which will allow you to save the "CREATE SQL" for a specific view which you could then execute with your database to copy to open. Make sure you modify the code and change any references to the database(s) that it may have.

Dan
Previous
Reply
Map
View

Click here to load this message in the networking platform