AnsweredAssumed Answered

Comparing Empty field to 0 returns true

Question asked by flukey on Dec 14, 2018
Latest reply on Dec 15, 2018 by john_wolff

Using FMPA 17.0.2.205 on Windows 10.

 

I have a number field in a record that is empty (no value entered):

Isempty(Field)  correctly returns 1 (True)

Field = 0  incorrectly returns 1 (True)

Field = 1 correctly returns 0 (False)

 

Obviously the second result is wrong since an empty field is clearly not = 0.

 

Is this a new bug?

Outcomes