Filemaker seems to not evaluate an if statement correctly

Discussion created by johannes on Jul 24, 2018
Latest reply on Jul 25, 2018 by fmpdude

Hi all,


since two days I am trying to find the reason for a strange problem. I have an if statement, that doesn't seem to evaluate correctly and I just can't see why. I am probably blind.


I attach a couple of screen shots, that should explain the problem.


A field that contains the letter "A" is evaluated in two statements:

1. a Set statement (just to have an alternative evaluation

2. an if statement


Both statements do not recognise the letter "A", although the data viewer clearly shows the letter "A".


Hope someone can see the obvious mistake that I don't see.


Thanks for your help.


Best regards