>I need to have a macro lcSqlStr - do I need to create a temporary file, if so, how do I exec it?
>
>Naomi indicates that VFP6 doesn't have Text To, so, what is the VFP6 way to run view?
>TIA

Something like (not tested)

lcTempPrgName  = SYS(2023) + "\" + SYS(2015)
SET TEXTMERGE ON NOSHOW
SET TEXTMERGE TO (lcTempPrgName + ".prg")
TEXT
...
ENDTEXT
SET TEXTMERGE TO
SET TEXTMERGE OFF
COMPILE (lcTempPrgName + ".prg")
DO (lcTempPrgName + ".fxp")
ERASE (lcTempPrgName + ".prg")
ERASE (lcTempPrgName + ".fxp")