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