Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why becoming error(operand type mismatch
Message
De
16/09/2005 14:49:47
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Database:
MS SQL Server
Divers
Thread ID:
01050437
Message ID:
01050451
Vues:
17
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform