Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy to
Message
From
16/02/1999 19:17:06
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00188110
Message ID:
00188186
Views:
26
As you've discovered, the way you are using COPY TO is creating a free table.

To help you solve your problem, tell us: do you want to back the data up to a table that is in the same dbc as the original table?

Let's say you have a DBC called MyDBC and a table called MyTable that you want to copy. Then you can do this:
USE MyDBC!MyTable  && Notice, the "MyDBC!" is usually not needed
COPY STRUCTURE EXTENDED TO tmpstru
CREATE myCopy DATABASE myDBC NAME MyCopyOfMyTable FROM tmpstru 
APPEND FROM MyTable
HTH

P.S. Unless you're typing commands, capitalization is interpreted as shouting (and rude).

>Please, HELP:
>WHEN I USE THE COPY TO to BACKUP MY TABLES I LOSE THE LINK WITH THE ORIGINAL DATABASE , LIKE I can MAKE A BACKUP OF MY TABLES WITHOUT LOSING THIS RELATIONSHIP
Previous
Reply
Map
View

Click here to load this message in the networking platform