AnsweredAssumed Answered

Calculation Should Be Blank But Queries As Though It Has Value

Question asked by dataWolf on Oct 29, 2009
Latest reply on Oct 30, 2009 by philmodjunk

Title

Calculation Should Be Blank But Queries As Though It Has Value

Post

I make a field that calculates integrity problems with the record. Then, I search for any records that have something in the error field. All the records that have data in the email field come up as having an error, though there is no text in the error calculation field when displayerd.

 

I've run into this problem before and can't quite identify what is going on.

 

It is of type text, unstored, self-references, no repitititions. I am using FMP9

 

Once again, my field "Error" is a case statement, the last field is "", when i do a find with * in this field, it finds all records that have text in a particular text field, but when I examine that calc field there is nothing in there. So why is the find behaving as though there is text in this field when there isn't anything in the results.

  

Thanks for any help! 

Outcomes