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

[Tom Sepper]

It's worked for us from FileMaker 4 up until 9. 


Tom Sepper
Director of Information Technology
Director's Choice Tour & Travel

P 806.762.6354
F 806.763.7637

tsepper at directorschoice.travel
www.directorschoicetourandtravel.com



-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org on behalf of Dale Bengston
Sent: Fri 7/13/2007 4:03 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] [OT] FM 9 Bug?
 
Hmm, doesn't null create an invalid relationship? I use 0 and 1 for  
boolean keys.

Dale


On Jul 13, 2007, at 3:50 PM, Tom Sepper wrote:

> 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.
>
>
> Tom Sepper
> Director of Information Technology
> Director's Choice Tour & Travel
>
> P 806.762.6354
> F 806.763.7637
>
> tsepper at directorschoice.travel
> www.directorschoicetourandtravel.com
> <winmail.dat>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3581 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20070713/6b573c5d/attachment.bin