Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Handling Null values in expressions
Message
 
To
08/03/2005 16:20:58
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00993816
Message ID:
00993818
Views:
14
>Is there anyway VFP can handle this rather then return the whole expression to .NULL.. I know you can use NVL(x,0), but I would think MS would handle this a different way.
>
>


Paul,

If you don't want to use NVL(), then how about:
IF !ISNULL(x) AND x < a
  DO something
ELSE
  DO nothing
ENDIF
HTH,
Chad
_________________________________
There are 2 types of people in the world:
    Those who need closure
Previous
Reply
Map
View

Click here to load this message in the networking platform