Hi all
I'm having a few problems dumping information from a table to a text file. The first couple of lines in the txt file need to be header data, while the rest is just info dumped from a table:
SET TEXTMERGE TO filename.TXT NOSHOW
SET TEXTMERGE ON
SELECT table
GO TOP
\<<'"3A"'>><<','>><<'000000'>><<','>><<'0000'>> etc etc
\<<'"3B"'>><<','>><<'000000'>><<','>><<'0000'"'>> etc etc
DO WHILE .NOT. EOF()
\<
>
SKIP
ENDDO
The problem is that the header lines are about 500 characters, and while I can get the first line in the text file ("3A") - when I try to include the second line ("3B"), the system hangs itself. I've tried to use the @SAY command however this says that the string is too long.
Does anyone know if there are limitations (eg string length) on using the "\" command??
Any help, comments would be appreciated!
Thanks
Chris Kable
FuelTrac