Kevin Cully wrote: > I'd go with Plan B. I've never liked surprises, and I can debug easier > if I have the SPT all put together for me before I try to execute it. I > usually do a TEXTMERGE to get the values into the SPT. > I've used TEXT/ENDTEXT in the past, but that was on SPT built right there in the data object PRG. In this scenario, I've tried something a bit different, having the SPT come in at runtime from a local DBF. That way, I can update the "view definitions" (but they're not actually VFP views, of course--just SELECT statements) without having to recompile the app.
Using the TEXTMERGE function worked beautifully....thanks, Kevin! -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.