Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy all fields including memo fields to .CSV file
Message
De
16/05/2003 15:38:02
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00787545
Message ID:
00789433
Vues:
21
Bill,
I don't know of any "reverse" example, but it shouldn't be too hard to write.

No, your append won't work. First, the syntax isn't quite right - instead try:
Append From (gcDelimFile) Delimited With " With Character ,

Next, as the test code I tried shows, VFP just skips over memo fields in an APPEND.
CREATE TABLE testappend (field1 C(10), Field2 N(10), field3 M, field4 C(250))
modi file testappend.txt
"ABC",1,"ABCDEFGHIJKLMNOPQRSTUVWXYZ"
"DEF",2,"ABCDEFGHIJKLMNOPQRSTUVWXYZ"

gcDelimFile = "testappend.txt"
Append From (gcDelimFile) Delimited With " With Character ,
Puts nothing into Field3 the 2nd string goes into Field4. I also tried it with:
"ABC",1,"ABCDEFGHIJKLMNOPQRSTUVWXYZ", "QQQQ"
"DEF",2,"ABCDEFGHIJKLMNOPQRSTUVWXYZ", "ZZZZZ"
And it just ignored that "4th" field.

Rick

>Thanks Rick
>I'll try it. By yhe way, How do you re-construct a vfp table from the resulting .CSV file?
>Will the following work? I have a feeling it will ignore the memo fields when constructing the .DBF.
>
>append from (gcDelimFile)
> delimited with """ with character ','
>
>Bill
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform