>TEXT TO cSqlCommand TEXTMERGE NOSHOW PRETEXT 7 > select mytable.field1, mytable.field2 from mytable > left join mytable2 on mytable.pk = mytable2.pk > where <<cSomeFilterExpr>> order by field1, field2 >ENDTEXT >TEXT/ENDTEXT stores the literal text contained into the variable, try changing your code to ...
TEXT TO cSqlCommand TEXTMERGE NOSHOW PRETEXT 7 select mytable.field1, mytable.field2 from mytable left join mytable2 on mytable.pk = mytable2.pk where <<cSomeFilterExpr>> order by field1, field2 ENDTEXT