>>TEXT TO lcstrsql TEXTMERGE NOSHOW PRETEXT 7 >> SELECT * from <<lcTable>> >> ORDER BY <<lcTag>> <<lcDirection>> >> INTO CURSOR <<lcNTable1>> nofilter >>ENDTEXT >>lcstrsql = STRTRAN(lcstrsql, CHR(13)+ CHR(10), SPACE(1)) >>&lcstrsql. >>>>
TEXT TO lcstrsql TEXTMERGE NOSHOW PRETEXT 7 >>> SELECT * from <<lcTable>>; >>> ORDER BY <<lcTag>> <<lcDirection>>; >>> INTO CURSOR <<lcNTable1>> nofilter >>>ENDTEXT >>>&lcstrsql>I have a select statement that is working off of a readwrite cursor that I created. I build the select statement within a Text...endText statement like this: