Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP9 and null values and NVL()
Message
 
 
À
24/07/2006 14:26:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01139317
Message ID:
01139351
Vues:
24
Yes, I got the same results:
ll = .t.
llNull = null
=messagebox(ll and llNUll)
=messagebox(ll or llNUll)
=messagebox(not llNull)
ll = .f.
=messagebox(ll and llNUll)
=messagebox(ll or llNUll)
=messagebox(not llNull)
However, try with char fields.

>I must be totally not undertanding the help:
>
>
>Null values persist through logical expressions in most cases. The following table describes the behavior of null values in logical expressions.
>
>Logical expression  Result if x=TRUE  Result if x=FALSE  Result if x=.NULL.
>x AND .NULL.            .NULL.             FALSE               .NULL.
>x OR .NULL.              TRUE              .NULL.              .NULL.
>NOT x                   FALSE              TRUE                .NULL.
>
>
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform