Anyone available for a quick reply? Schools are closing early for
hurricane Sandy and I'd like to resolve this before an involuntary long
weekend babysitting :-(
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay
Sen
On Thu, Oct 25, 2012 at 12:49 PM, Rick Debay wrote:
> > I'd have to say that for foreign key relationships a null in the
> referencing field is considered to match
>
> How about in the referenced field? BTW, thanks for the quick reply.
>
The referenced fields have to be subject to a primary or
rrison
Sent: Thursday, October 25, 2012 10:33 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Compound foreign key & null value bug?
Rick,
> I forgot to populate the new column in the child table, so all the
> relationships looked like this:
>
> Child Parent
Rick,
> I forgot to populate the new column in the child table, so all the
> relationships looked like this:
>
> ChildParent
> ---
> Col1:null -> Col1:A
> Col2:B-> Col2:B
>
> The new foreign keys were created without any errors. Since (null,B)
> doesn't match anything