>Missing a ";" at the end of each lines:

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:
>>

>>    TEXT TO lcstrsql TEXTMERGE NOSHOW PRETEXT 7
>>      SELECT * from <<lcTable>>
>>        ORDER BY <<lcTag>> <<lcDirection>>
>>        INTO CURSOR <<lcNTable1>> nofilter
>>    ENDTEXT
>>    &lcstrsql.
>>
>>

>>a browse window comes up in the exe over my form, which is Not suppose to happen, and then I get alias not found when I try to work with the resulting cursor.
>>
>>Can anyone point out what I am doing wrong?
>>
>>TIA
>>Beth

I thought I did not need them. I thought someone had did the same thing without ';' and worked fine. "I thought" was missing a piece, the piece about stripping out the CRLF.

Thanks for your help also on this matter.

going to bang my head on wall for a while. :D

Beth