Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Appending More than 254 Character in a record From Text
Message
De
19/08/2013 17:27:11
 
 
À
19/08/2013 17:03:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01580757
Message ID:
01580790
Vues:
53
If there is lots of data, that will be SLOW and chew up memory and disk space fast.

>Perhaps you can use combination (as suggested earlier) of techniques. You can use FGETS() to read the file line-by-line, then use temporary table, but rather than using a character field, use a memo field. I do vaguely recall the original memory thread (though can't remember the exact details of what you were trying to do). I suspect you might've run into a problem if you were trying to read the entire file in one step using FILETOSTR(). Although ALINES() could be used, it also runs the risk of crashing if the file contained enough lines to cause array to contain too many elements (>65000 elements). Using FGETS() to read the file line-by-line would get around that problem.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform