[FX.php List] [OT] FM 9 Bug?

[Troy Meyers]

Tom,

I haven't tried this, but it was mentioned in the Read Me notes of FileMaker 9.

>From the "FMP Read Me (English).pdf" file:


     11.11.	 In the previous versions of FileMaker, some predicates in a
     relationship would be ignored if they had an empty value. This could
     result in finding records which don?t match the relationship
     criteria,  even finding all records in the related table. Predicates
     based on empty values will no longer match  to any other records. Any
     databases which depended on the old behavior will need to be modified
     to  use a different relational design. This change was made to match
     standard relational behavior in  SQL databases.
     
-Troy


> I came across an odd bug in FileMaker 9 and was wondering if anyone
> could verify.
> 
> Two tables. Table one has a calc field that simply has a numeral 1.
> Table two has a boolean number field; 1 indicates yes, null indicates
> no.  Relationship is if the calc 1 field does not equal the boolean
> field.  
> 
> What I've discovered is that FileMaker now does not accept the null
> value in the relationship. No longer can you see from table 2 back to
> table 1.
> 
> Table 1 is the many; table 2 is the one.
> 
> Can anyone concur? 
> 
> If so, this is a huge block in adapting FM 9 for my database solution.