Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Change in Behavior: SELECT SUM(x)?
Message
De
16/03/2006 14:01:14
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Change in Behavior: SELECT SUM(x)?
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01105012
Message ID:
01105012
Vues:
63
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform