>>In vfp60, in my table… I want to check a field that has a data type of CURRENCY. I want to see if this field is empty or not. I have tried…
>>?empty(myfld)….this returns a F…but the field seems to be empty....
>>?myfld...returns nothing...
>>Any ideas?
>
>Rob,
>
>I'm assuming that you mean that no data has been inserted into the record. In some cases you can use the ISBLANK() function to determine this. Unfortunately, with the currency data type, this doesn't apply. For example,

CREATE CURSOR Foo (Money Y, SomeNum N(8, 2))
>* No records
>? ISBLANK(Foo.Money) && returns .F.
>? ISBLANK(Foo.SomeNum) && returns .T.
>* Add a record
>APPEND BLANK
>? ISBLANK(Foo.Money) && returns .F.
>? ISBLANK(Foo.SomeNum) && returns .T.

In both cases, the EMPTY() function returns .T.
--------------
Hi George...nice to hear from you again...
I have many records in my table...when I code ...?empty(my_currency_fld)...
it return F...then I put a zero in the my_currency_fld field and...code...
?empty(my_currency_fld)...it returns T...what is up?...ISBLANK(my_currency_fld)
return F in either case..How can I check for my_currency_fld being EMPTY or
not...?I do not want to initialize my_currency_fld with zeros???