>>>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.
-----------
Hi Trey....
?round(my_currency_fld,12) = 0 ...returns .F....round(my_currency_fld,12) = 0 returns .T. if there is a zero in the fld and it returns a false it anything else is in the field... round() does not help this situation....thanks...:)