Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
I need help with null values
Message
De
07/08/2001 14:33:33
Mike Sue-Ping
Cambridge, Ontario, Canada
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
I need help with null values
Divers
Thread ID:
00540860
Message ID:
00540860
Vues:
79
I have a VFP6.0 table with a numeric field (named say f1) that supports null values. If I make all records have f1 equal null and issue the following commands:

STORE .NULL. TO x
CALCULATE AVG(f1) TO x

I expected to see NULL as the result but instead VFP returns 0.000.

Is there anyway to have NULL returned when all values for the field are null?

TIA. Mike
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform