Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Text and endtext
Message
From
01/11/2005 23:47:02
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01064104
Message ID:
01064345
Views:
20
>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 )

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform