Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to quickly look at Memo files, converting table to a
Message
 
À
16/01/2013 16:28:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01563035
Message ID:
01563039
Vues:
49
>>Hi Gang!
>>
>>I have a table with some memo fields in it (along with some Character fields).
>>
>>I wanted to copy the data out quickly to a Text File.
>>
>>I tried
>>
>>COPY TO C:\TOMMY.TXT TYPE CSV
>>
>>but this only copied out the Character fields.
>>
>>How do I get the Memo fields out for analysis?
>>
>>Thanks!
>
>Try to list the fields, and use a function, for instance padr(yourmemo,250), for the memo field. Or you can List them
>List off field1,field2,padr(fieldmemo,250) to file somefile.txt noconsole
BRILLIANT !!! (now all I need is to get the comma's in between the field output)....

Thanks!
Tommy Tillman A+ NetWork+ MCP
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform