General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Beautiful!
Thanx Edward and John!
>Hi Ian:
>
>USE database1!mytable
>COPY TO C:\otherdirectory\mytable WITH CDX DATABASE database2
>
>Do this will all tables and then go and copy the files back to the original directory.....go back into the new combined database and dbl-click on each table....you'll be forced to Locate each table...fine, locate 'em.
>
>Problem resolved.
>
>
>>I have 3 distinct VP6 Databases that I wish to merge into one database, without losing any information.
>>
>>If I try to add a table from one DB into another DB, VFP informs me only Free Tables can be added to a DB. If I remove a table from a DB to make it a Free Table, I lose my long file names, which obviously not very desireable - these are big tables.
>>
>>I can not find any documentation on this issue.
>>
>>Is there any way around this catch 22???
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only