Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copying data from memo fields
Message
 
 
To
31/07/2001 21:02:31
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00538111
Message ID:
00538115
Views:
18
This message has been marked as the solution to the initial question of the thread.
Your transfer file should have memo field with the same name as in vp1.dbf to transfer memo info.
use tvp1
append from vp1 for recno()>3000
copy file tvp1.dbf to a:\tvp1.dbf
copy file tvp1.fpt to a:\tvp1.fpt
If tvp table has the same structure as vp table than even shorter
use vp1
copy to a:\tvp1 for recno() > 3000
>I need to transfer a number of records from a table in one system (system 1) via floppy/email to another system (system 2). The table concerned has a memo field which needs to be transferred to system 2 as well.
>
>System 1 extracts a selected number of records from vp1.dbf to a transfer file tvp1.dbf, then copies tvp1.dbf to the floppy, ie
>
>use tvp1
>append from vp1 for recno()>3000
>copy file tvp1.dbf to a:\tvp1.dbf
>
>To make sure that the memo contents of the selected records from vp1.dbf are transferred as well, I also include:
>
>copy file vp1.fpt to a:\tvp1.fpt
>
>and when the records from tvp1 are added to system 2, the memo field contents are added as well.
>
>BUT of course tvp1.fpt above includes the memo contents of ALL records in vp1.dbf, which means it is a huge file and makes for a problem with disk space etc.
>
>Question - Is there any way I can transfer the memo contents of the selected records ONLY in tvp1.dbf to tvp1.fpt?
>
>Any ideas gratefully received
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform