Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP9 and null values and NVL()
Message
 
 
To
24/07/2006 14:26:30
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01139317
Message ID:
01139351
Views:
21
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
Previous
Reply
Map
View

Click here to load this message in the networking platform