value of lcstrsql

SELECT * from prodct
ORDER BY date_purch ASCENDING
INTO CURSOR mnprodct1 nofilter
update:
with code to take out CRLF

SELECT * from prodct ORDER BY date_purch ASCENDING INTO CURSOR mnprodct1 nofilter

>Beth,
>
>What is value in lcstrsql variable?

>STRTOFILE(lcstrsql, "lcstrsql.txt")
>MODIFY FILE "lcstrsql.txt"
>

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