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 TempWhen 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 TempWhy ?