Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving Tables Between Databases
Message
 
To
25/02/2004 14:10:48
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00880647
Message ID:
00881102
Views:
18
>Is there a way to move data tables from one DBC to another, aleady-exisiting database without first freeing it (which I assume will lose all DBC-specific stuff like captions and long field names)? Long ago, I dumbly put one of application's tables into three different databases (each in a different folder) and would like to consolidate them. I've no problem hacking the database files if needed, but am not sure of everything I should look out for.

>> If one of your existing tables is the right one, why not just append from >> the other two and then drop these two?

Sorry, what I should have said is that I dispersed the application's tables into three different databases, not that I had duplicated any one table in more than one DBC. Other respondents reminded me of the DATABASE parameter in VFP's COPY TO command, which was what I needed. Thanks!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform