Just a correction, I know that you can't check it right now but VFP9 extends the PRETEXT flag, that way you can have a command w/o need to STRTRAN() it after that:

  text to lcSelect noshow PRETEXT 15
       Select bp_eng.engkod, bp_ten.t_szam, bp_ten.tcs_szam,
              bp_ten.tipus, bp_ten.suly, bp_ten.ttav, bp_ten.kszam, bp_ten.ktav
       From bp_eng
       LEFT JOIN bp_ten ON ALLTRIM(bp_eng.engkod) ==  ALLTRIM(bp_ten.engkod)
       Where bp_eng.engkod == "UE00000106"
       into cursor temp2
endtext
? lcSelect

PRETEXT expressions are:

1  Eliminate spaces before each line.
2  Eliminate tabs before each line.
4  Eliminate carriage returns, for example, blank lines, before each line.
8  Eliminate line feeds. && New in VFP9

>

>text to lcSelect noshow
>  Select bp_eng.engkod, bp_ten.t_szam, bp_ten.tcs_szam,;
>  bp_ten.tipus, bp_ten.suly, bp_ten.ttav, bp_ten.kszam, bp_ten.ktav;
>  From bp_eng LEFT JOIN bp_ten;
>   ON ALLTRIM(bp_eng.engkod) ==  ALLTRIM(bp_ten.engkod);
>   Where bp_eng.engkod == "UE00000106";
>   into cursor temp2
>endtext
>
>lcSelect = strtran(m.lcSelect, ";" + CRLF, " ")
>
>&lcSelect

>
>>Hi,
>>Can anyone help me explain why this does not work:
>>

>>lSelect = 'Select bp_eng.engkod, bp_ten.t_szam, bp_ten.tcs_szam,;
>> bp_ten.tipus, bp_ten.suly, bp_ten.ttav, bp_ten.kszam, bp_ten.ktav;
>>  From bp_eng LEFT JOIN bp_ten;
>>   ON ALLTRIM(bp_eng.engkod) ==  ALLTRIM(bp_ten.engkod);
>>   Where bp_eng.engkod == "UE00000106";
>>   into cursor temp2'
>>
>>? AT('"',lSelect)
>>

>>
>>I get the message "Command contains unrecognized phrase...".
>>If I leave out the "Where..." clause, it runs all right.
>>
>>Thanks
>>Tamas