Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Building a string
Message
De
05/04/2010 15:01:58
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01458765
Message ID:
01458794
Vues:
62
Thanks Naomi - the solution I am using appears adequate for the file size I am working with.

>Did you try fput solution too ?
>
>Also, remove lcLine at all from your strtofile test (write directly without lcLine variable).
>
>>Sergey, I have done some tests. Your suggestion is much slower (17.2 sec) compared to building a string (0.75 sec) or using TEXTMERGE (0.8 sec). It would seem that for the file size I am using that building the string is a good option.
>>
>>UPDATE: I am using 10,000 records and combining 3 fields.
>>
>>
>>>It has been proven that writing to a file line by line could be faster than building string in a memory.
>>>I would try
>>>
>>>lcFileName = "..."
>>>ERASE(lcFileName) 
>>>SCAN 
>>>
>>>lcLine = myTable.Field1 + CHR(9) + myTable.Field2 + CHR(9) + CHR(13)
>>>
>>>STRTOFILE(lcLine , lcFileName, .T.)
>>>
>>>ENDSCAN
>>>cMyString = FILETOSTR(lcFileName)
>>>
>>>
>>>>I need to add extra formatting text between fields and dependent on field contents. So simple COPY will not work. Do you think using SET TEXTMERGE TO VARIABLE will be faster?
>>>>
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform