Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table with Memo field Export to txt file ?
Message
 
À
28/10/2002 09:58:39
Agnes Cheng
DynamicTech Consultants Ltd.
Hong Kong, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00716035
Message ID:
00716068
Vues:
16
Memo field contents may be very long and may contain chr(13) and chr(10) indicating line end. So the solution depends on how you need to handle these line breaks and long content in the particular record and on how they need to be inserted into text file. Otherwise something like this:

use (yourtable)
lnfp=fcreate("outfile.txt")
scan
fputs(lnfp,alltr(memofield))
endscan
=fclose(lnfp)

>I got a table which got one memo field only.
>I will generate 30-50 records each time and then export them into *.txt format.
>My txt file format must be 1ine feed.
>It means. 1 record pre 1 line .
>How can i do that ???
>
>Thanks in advance.
>From Agnes
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform