Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uses of count command with sql
Message
 
 
To
11/09/2005 12:45:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01048512
Message ID:
01048536
Views:
16
>on VFP9 you can simplified this ( and return a integer ):
>
>SELECT examcode,;
>		descr, scode,;
>		lcode, sec,
>		SUM( CAST(res01 = "pass" AS I)) AS pass01, ;
>
>....
>
Fabio,

It doesn't look simplier to me and it's certainly harder to understand.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform