Should be "{^"


>Good evening Sergey,
>
>I have a syntax error...?
>
>

>ddebut = "^{" + TRANSFORM(DTOS(THISFORM.ddebut), "@R 9999/99/99") + "}"
>dfin = "^{" + TRANSFORM(DTOS(THISFORM.dfin), "@R 9999/99/99") + "}"
>
>
>  TEXT To cValue NOSHOW TEXTMERGE
>    SELEC T.Cnomteleph , T.iid FROM Employee E INNER JOIN TELEPH T ON E.iTelephoneid = T.iid ;
>    INNER JOIN Horaire H ON E.iid = H.iEmployeeId ;
>    WHERE H.ddate BETW  <<m.ddebut>> AND  <<m.dfin>>   ;
>    GROUP BY 1 , 2 INTO ARRAY taSelectedList
>  ENDTEXT
>
>

>
>
>>You've to convert THISFORM.ddebut and THISFORM.dfin to proper date literals. Something like

? "^{" + TRANSFORM(DTOS(DATE()), "@R 9999/99/99") + "}"

>>>
>>>Sorry a little mistake.
>>>
>>>

>>>TEXT To lcSql 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 ?
>>>
>>>thank in advance
>>>
>>>bernhart