Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COPY FILE
Message
 
To
14/12/2000 05:37:19
Gad Hutt
Express Print
Herzliya, Israel
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00452774
Message ID:
00453812
Views:
21
>>>Gadi Hutt
>>

>>You have copied a file which belongs to a database. As i recall, you have done this to keep the long field names you are using. (See yoúr older threads.)
>>What you can do is the following.
>>At the client side copy the data to a new free table.
>
>Hi Ko,
>Again thanks for your answers.
>I can't use the CREATE TABLE, because I wnat to dynamiclly copy different tables, with differrent structure, that is why after you told that the field name has a limited length, I tried to use the COPY FILE command that duplicates files. And this is good for me, all I need to know is how to eliminate the DATABASE BACKLINK and the READ ONLY status of the copied tables, and I'll be done.
>
>Many Thanks,
>Gadi


I don't know if that van be done, but then the problem i still there. The long field names are stored in the database and not in the table itself.
What you can do is export to another file type, or create a xml string.
You can also copy the database with the files. If you for example have four tables that has to be transported, you can place them in a seperate database.
A third thing you could do, is creating an extra table. In that table you can make a list of the short field names, and the long field names.
You then can probably create a temporary dbc at the server site. Add the free table that is exported to that database, and then use the extra table to change the field names back to the long names. Now you can simply append from that table.

HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform