Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you see of a field if EMPTY.
Message
From
25/10/2000 10:27:14
 
 
To
25/10/2000 10:19:18
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00434009
Message ID:
00434033
Views:
15
>>CURRENCY type is near of NUMERIC type.
>>AND an empty value for NUMERIC type don't exist
>>because 0 is a value.
>>
>>YOU CAN JUST TEST IF YOUR VALUE = 0 OR NOT.
>------------
>Hi Alexandre:
>I have tried that.. Hear is my code:
> *myfld= currency data type
>
>if myfld=0
> ?'myfld is 0'
> else
> ?'myfld is not 0'
> endif
>This returns the ELSE part...?empty(myfld) returns a .F.,...what is up?

The value is not 0.
EMPTY() returns .F. for any field that is set to it's lowest possible value - e.g., numeric = 0, currency = 0, logical = .F., character or memo = "", date = {}, etc.

If you ? myfld does it show 0.000?

Check if ROUND(myfld,12)=0 - if not, check what ROUND(myfld,12) is.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform