Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I check if numeric field is 0 or blank
Message
From
26/08/1999 13:30:33
 
 
To
26/08/1999 10:23:29
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00257901
Message ID:
00258048
Views:
19
Thanks, but it didn't work.
Here is the results of some of my testing.

goto 2 this is 0.0
?isnull(hcl) shows false (right to me)
goto 3 This is a blank
?isnull(hcl) shows false (wrong to me)
go bott This is a newly appended blank record with only Sampl# & date
?isnull(hcl) shows false (wrong to me)
goto 2 thi is 0.0
? empty(hcl) shows true (wrong to me)
goto 3 this is blank
? empty(hcl) shows true (right to me)
go bott this is a new blank record
? empty(hcl) shows true (right to me)

The hcl field is Numeric 4,1 decimal I had the NULL box checked, origianlly I didn't but the results were the same.

Any more ideas would be really appreciated.
Thanks. Gary
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform