Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding .null.+.null.+1 = .null. ????
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00105526
Message ID:
00105913
Vues:
36
>Hi,
>
>In a joint view, I got null values.
>
>In the report I had a .null.+.null.+ a value but it shows nothing.
>The line below it is: .null. + 100 = 100 it works.
>
>As a work around, I had to put IIF() to return 0.
>
>Is there restriction/bug on adding nulls.
>
>I got version 5.0a.
>
>Steve
>Thanks in advance for your answers.

Steve,

Here's how I think of it. .NULL. means "I don't know". So imagine the question then, in this context. If I add an unknown value to 100, what's my answer? Gee, I don't know.

That's why .NULL. + Anything = .NULL.

Hope this helps.
Menachem Bazian, CPA
President
BC Consulting Services, Inc.
973-773-7276
Menachem@BazianCentral.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform