EMPTY()
, ISBLANK()
, and ISNULL()
please run the following little program and look at the results.*!* "Is there any function that can distinguish between *!* the zero and the apparently blank entry?" *!* Only ISBLANK() can distinguish between *!* zero and "never entered" in a numeric field. CREATE CURSOR Dummy ; (nDummy N NULL, nValOfDummy N NULL, lISBlank l, lISNull l, lEmpty l) APPEND BLANK REPLACE nValOfDummy WITH nDummy, ; lIsBlank WITH IsBlank(nDummy), ; lIsNull WITH ISNULL(nDummy), ; lEmpty WITH EMPTY(nDummy) APPEND BLANK REPLACE nDummy WITH 0 REPLACE nValOfDummy WITH nDummy, ; lIsBlank WITH IsBlank(nDummy), ; lIsNull WITH ISNULL(nDummy), ; lEmpty WITH EMPTY(nDummy) APPEND BLANK REPLACE nDummy WITH .NULL. REPLACE nValOfDummy WITH nDummy, ; lIsBlank WITH IsBlank(nDummy), ; lIsNull WITH ISNULL(nDummy), ; lEmpty WITH EMPTY(nDummy) BROWSE>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…