Hi Tamas,

Most probably it has to do with the text wrapping. Try ending the string before each semicolon, and concatenate with rest. Something like:

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'

HTH

>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