>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
If TVP1 has the same structure as VP1 then the memo is appended too. But I gather TVP1 doesn't have the same structure. Is that correct?
Does TVP1 have data in it already, and that's why you're APPENDING into it, instead of just doing a COPY [FIELDLIST] TO aTransferFile from VP1?
>and when the records from tvp1 are added to system 2, the memo field contents are added as well.
Hm. How do you do this? Whatever it seems it would be easiest if you just sent a structure that matched...DBF + FPT.
>Question - Is there any way I can transfer the memo contents of the selected records ONLY in tvp1.dbf to tvp1.fpt?
Er. Is there a typo there? Did you mean "records ONLY in vp1.dbf to tvp1.fpt," by any chance?
USE VP1
COPY TO TVP1 FOR RECNO() > 3000
COPY FILE TVP1.* TO A:\*.*
Hope I haven't misunderstood something. Oh, and you might want to look at a compression tool such as DynaZip if you're starting to reach the limits of a floppy.