Chris,
What line is hanging? There isn't a limit to the size of the string output by \. The following example creates lines 6000 characters long:
x1 = replicate( "abc123", 1000 )
set textmerge to testlen.txt noshow
set textmerge on
\<<x1>>
\<<x1>>
\<<x1>>
set textmerge off
set textmerge to
Also you should use a SCAN loop instead, it'll be a little faster:
SELECT table
...
SCAN
\<<account_num>>
ENDSCAN>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??
