Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Handling Null values in expressions
Message
From
08/03/2005 16:20:58
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Handling Null values in expressions
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00993816
Message ID:
00993816
Views:
44
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.


EXAMPLE

x=mytable.myfield &&WHICH EVALS TO .null.
a=1

IF x DO something
ELSE
DO nothing
ENDI
Next
Reply
Map
View

Click here to load this message in the networking platform