Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why becoming error(operand type mismatch
Message
From
16/09/2005 14:29:15
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Why becoming error(operand type mismatch
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01050437
Message ID:
01050437
Views:
55
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
Next
Reply
Map
View

Click here to load this message in the networking platform