Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP9 and null values and NVL()
Message
From
24/07/2006 14:40:44
Naomi Nosonovsky
Wisconsin, United States
 
 
To
24/07/2006 14:33:45
Tc Holzer
Isle of Man
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: VFP9 and null values and NVL()
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01139317
Message ID:
01139359
Views:
33
>Well, NVL() appears to do what it should at least:
>
>CREATE TABLE testtab (lvalue L null)
>APPEND BLANK
>REPLACE lvalue WITH .t.
>APPEND BLANK
>REPLACE lvalue WITH .f.
>APPEND BLANK
>REPLACE lvalue WITH null
>GO top
>SCAN NEXT 10
>   ? lvalue
>   ? ISNULL(lvalue)
>   ? (NVL(lvalue,.f.))
>   ?"-------------------"
>endscan
>
So keep it <g>
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