>>>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 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 >>>
select myTable.field1, myTable,field2, from myTable left join myTable2 on myTable.PK = myTable2.pk where < < cSomeFilterExp r> > order by Field1, Field2 into cursor myCursornotice that in case you are using Text...EndText the continuation mark ; and + are missing, since text...endtext is making indeed one big line, but that line you will never ever (I hope) have to read. Just read your code.