I'm modifying a foreign key from one column to two.
I dropped the original foreign key from the child table, populated the
new columns, and then created the new key.
I forgot to populate the new column in the child table, so all the
relationships looked like this:
ChildParent
-
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
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
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
Debay
Sent: Wednesday, October 24, 2012 10:50 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Compound foreign key & null value bug?
I'm modifying a foreign key from one column to two.
I dropped the original foreign key from the child table, populated the
new columns, an