Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why becoming error(operand type mismatch
Message
From
16/09/2005 14:49:47
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01050437
Message ID:
01050451
Views:
12
>Dear all, i am try to using these codes but i have error
SET ENGINEBEHAVIOR 70
>SELECT lcode,sec,descr,examcode, sum(tobt)		as 		tobtt,;
> SUM(tmax)		as tmaxt;
> FROM Examtran;
>WHERE examcode=thisform.code.value .and. scode>=thisform.shiftfm.value .and. scode<=thisform.shiftto.value;
> GROUP BY lcode,sec;
> INTO CURSOR tyu
>brows
>
>SELECT lcode,sec,descr,examcode,tobtt,tmaxt,;
> TRANSFORM((tobtt/tmaxt)*100,"##.##") AS PERCENTAGE;
> FROM tyu;
>WHERE examcode=thisform.code.value .and. scode>=thisform.shiftfm.value .and. scode<=thisform.shiftto.value;
> GROUP BY lcode,sec;
> INTO CURSOR ppp
> SELECT ppp
> brows
>Sorry i am using vfp data not using ms sql server

What are the types of the control properties you're accessing. It sounds like as last one is not the type you expect it to be.

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform