Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying data from memo fields
Message
 
À
31/07/2001 21:02:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00538111
Message ID:
00538175
Vues:
17
It could be done with xbase as the others suggest. You could also copy the required data to a temporary directory and use backup to contiguously transfer data to a floppy or winzip it!

>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
Imagination is more important than knowledge
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform