>>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.