Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weird-Record Pointer
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01507019
Message ID:
01507055
Views:
47
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform