Thank you.

I did not know that one could put a parameter!




>>Hi All,
>>
>>

>> TEXT To cValue NOSHOW TEXTMERGE
>>SELEC T.Cnomteleph , T.iid FROM ;
>>Employee AS 'E' INNER JOIN TELEPH AS 'T' ON E.iTelephoneid = T.iid ;
>>    INNER JOIN Horaire AS 'H' ON E.iid = H.iEmployeeId ;
>>    WHERE H.ddate BETW  <<THISFORM.ddebut>> AND <<THISFORM.dfin>>  ;
>>    GROUP BY 1 , 2 INTO ARRAY taSelectedList
>>  ENDTEXT
>>
>>  =EXECSCRIPT( lcSql )
>>
>>

>>
>>I have a strange error "Operator/operand type mismatch. " ( perhaps thisform.ddebut ? )
>>
>>What can i do ?
>
>I thought someone would bring this up... you can pass a parameter:
>
>

> TEXT To cValue NOSHOW TEXTMERGE
>lparameters dFrom, dTo
>SELEC T.Cnomteleph , T.iid FROM ;
>Employee AS 'E' INNER JOIN TELEPH AS 'T' ON E.iTelephoneid = T.iid ;
>    INNER JOIN Horaire AS 'H' ON E.iid = H.iEmployeeId ;
>    WHERE H.ddate BETW  dFrom AND dTo  ;
>    GROUP BY 1 , 2 INTO ARRAY taSelectedList
>  ENDTEXT
>
>  =EXECSCRIPT( lcSql, thisform.ddebut, thisform.dfin )
>
>