Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Avoiding NULL with SUM
Message
De
14/01/2005 13:10:41
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00977283
Message ID:
00977291
Vues:
26
>>With VFP 9, if you SUM a column and the where clause doesn't return any data, you end up with NULL. How can I obtain 0?
>
>Try
NVL(SUM(...), 0))
From that side, it works. But, isn't there a setting I could turn ON in VFP 9 to avoid changing all that in the code?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform