Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change in Behavior: SELECT SUM(x)?
Message
From
16/03/2006 14:01:14
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Change in Behavior: SELECT SUM(x)?
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01105012
Message ID:
01105012
Views:
62
I've found a change in behavior between VFP 8.0 and VFP 9.1 (I did not test this in VFP 9.0). Is this an intended change in behavior? This does not appear in Hentzenwerke's "What's New In 9":

For this statement:
SELECT SUM(nMyColumn) FROM MyTable WHERE MyCondition ...

When no rows exist that satisfy MyCondition,

VFP 8.0 returns: _TALLY = 0

VFP 9.1 returns: _Tally = 1, the returned result is .NULL.

Is this the way it's supposed to work now?
If so, this will 'break' a lot of existing code.

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform