>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))
? ISBLANK(Foo.Money)
? ISBLANK(Foo.SomeNum)
APPEND BLANK
? ISBLANK(Foo.Money)
? ISBLANK(Foo.SomeNum)
In both cases, the EMPTY() function returns .T.
George
Ubi caritas et amor, deus ibi est