>TEXT TO .SelectCmd NOSHOW PRETEXT 15 TEXTMERGE
> select cntr_orig, company, contact, cr_by, cr_date, edi, email, fax, ident, langue, mainaddr1, mainaddr2, maincity,maincntry, mainstate, mainzip, note, phone, place_exp, taxid, titre, vendno, vfdcode, webpage from dovendor WHERE DOVENDOR.IDENT = L_IDENT
> ENDTEXT
>
>
>
>the l_ident is a value and not a name field
>
>and i get an error invalid column name l_ident
>
>
>how can i do
>
>thanks ??
What do you mean? You mean it's a variable?
TEXT TO .SelectCmd NOSHOW PRETEXT 15 TEXTMERGE
select cntr_orig, company, contact, cr_by, cr_date, edi, email, fax, ident,
langue, mainaddr1, mainaddr2, maincity,maincntry,
mainstate, mainzip, note, phone, place_exp, taxid,
titre, vendno, vfdcode, webpage from dovendor WHERE DOVENDOR.IDENT = ?m.L_IDENT
ENDTEXT
Cetin