Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why becoming error(operand type mismatch
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Why becoming error(operand type mismatch
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Database:
MS SQL Server
Divers
Thread ID:
01050437
Message ID:
01050437
Vues:
58
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform