>Hi all?
>
>When i try this code i haven't error.
>
>

>dvd = DATE()
> ccondit = ' ?dvd BETWEEN E.Ddebut AND E.Dfin '
>
>  SELECT   Teleph.cnomteleph AS 'cnom' ,  e.ddebut   ;
>    FROM ( (  amline!Resident AS 'R' ;
>    INNER JOIN amline!Teleph Teleph ON  R.itelephoneid = Teleph.iid ) ;
>    LEFT OUTER JOIN amline!Etats AS 'E' ON R.iid = e.iresidentid );
>    WHERE &ccondit  ORDER BY 1 INTO CURSOR Temp
>

>
>When i try this Code i have a syntax error !
>

>dvd = DATE()
> ccondit = ' ?dvd BETWEEN E.Ddebut AND E.Dfin '
>
>  SELECT   Teleph.cnomteleph AS 'cnom' ,  e.ddebut   ;
>    FROM ( (  amline!Resident AS 'R' ;
>    INNER JOIN amline!Teleph Teleph ON  R.itelephoneid = Teleph.iid ) ;
>    LEFT OUTER JOIN amline!Etats AS 'E' ON R.iid = e.iresidentid );
>    WHERE EVAL( ccondit )  ORDER BY 1 INTO CURSOR Temp
>

>
>
>Why ?
>I want to use the command 'evaluate' because it appears that faster ?

Bernhart,

In case when you replace a part of VFP command you can use macro substitution only. The EVAL() function can evaluate expressions only and ' ?dvd BETWEEN E.Ddebut AND E.Dfin ' isn't valid expression.