Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Different behavior of COUNT(*) and SUM()
Message
From
03/11/2008 13:04:57
William Benavente
JZANUS
New York City, New York, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Different behavior of COUNT(*) and SUM()
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01359217
Message ID:
01359217
Views:
80
Hi,

If I select records that don't satisfy my criteria I get 0 for count(*), but NULL for sum(IIF(myCondition, 1,0))

Is this a documented beahvior?

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform