Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Text and endtext (2)
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01064109
Message ID:
01064114
Views:
27
This message has been marked as the solution to the initial question of the thread.
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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform