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 ? lcSelectPRETEXT 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>
>>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) >>>>