>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