Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Weird-Record Pointer
Message
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 SP2
Database:
Visual FoxPro
Divers
Thread ID:
01507019
Message ID:
01507055
Vues:
49
As you already found your problem, just another observation:
your code puts vfp probably through some unneccessary gyrations.
I'd code as
SELECT tmpData
SET ORDER TO ID

outputFileName=outputPath + SUBSTR(DTOS(RunDate), 5) + "_" + "BOGUSTEST.TXT"
ERASE (outputFileName)
fh=FCREATE(outputFileName)	&& Default is Read/Write in FCREATE().
IF fh > 0
	* File creation succeeded! Now, write the header to the text file.
	=FPUTS(fh, lcHeader)	&& The Header string, lcHeader, was created earlier.
	*  GO TOP  believe in vfp Docs!
	SCAN
		* Assemble the text data.
		lc = m.GrpID ;
		    + m.GrpNum ;
		    + PADR(m.FirstName, 15) ;
		    + IIF(EMPTY(m.Initial), " ", m.Initial) ;
		    + PADR(m.LastName, 20)
and not use the vfp textmerge, as this way is still optimized but also
as easy to translate into almost any language as the original, if asked for.

my 0.02 €

thomas
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform