General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Change in Behavior: SELECT SUM(x)?
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only