Hi Thomas,
Thanks for the reply.
I haven't tried it yet, but, I don't believe that your suggestion is going to help. The string, lcmd, does not grow to any considerable size within that loop. lcmd really contains only something like:
INSERT INTO CSRJUNK (F1, F2, F3) VALUES ("TEST1", "TEST2", "TEST3")
when that loop finishes.
There is an outer loop that progresses thru the 63000 "records" and each time it does the inner loop to build lcmd to do the SQL-INSERT.
Regards,
Mike
>try
>
>lcFile = "Tst.txt"
>= strtofile(m.lcmd, m.lcFile, 0)
>FOR m.li = 0 TO m.liNumDesc-1
> * m.lcmd = m.lcmd + ["] + oChildNode.ITEM(m.li).TEXT + [",]
> = strtofile( ["] + oChildNode.ITEM(m.li).TEXT + [",], m.lcFile, 1)
>ENDFOR
>
> as this eliminates the heavy memory copies as the string grows.
>
>HTH
>
>thomas