>Things have been a “bit hectic” around here so it took some time to get back to you.
>
>When I attempted to compile I received the message, “Command contains unrecognized phrase/keyword". I finally got over that problem. As the query becomes more complex I will realize if there are limitations for what I have to accomplish.
>
>Thank you for your response and suggestions. Part of the problem was the 255 character limit. VFP 6 does not have the Text/EndText function so I am trying Mike’s suggestion. Thank you for the error code - it lets me know when there is a problem. :)
>
>I am trying to convince management to upgrade to VFP 8. That may help a bit.
Until then, you can do textmerge into a file, give it a .prg name, and compile it (provided you're at least vfp6 sp3 or sp4, don't remember exactly which one was it) on-the-fly and run it.
As to Esparta's version of the same suggestion, I'm not sure the memvar clause was supported back then. AFAIR, it appeared in VFP7.