Oops, I didn't realize that. Sorry and thanks for catching it.
>The PRETEXT 15 require VFP9.
>
>>Quick note here. 1st what Sergey said is how we do it and it works great. 2nd: replace the
text TO lcSql noshow
with
TEXT TO sqltxt noshow pretext 15 TEXTMERGE
and you won't have to use the
>>
sqltxt = CHRTRAN(lcSql, CHR(13), CHR(10), '')
the PRETEXT 15 parameter does it for you.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn