Book a Demo

Author Topic: Probs or Bug /w FKs referencing  group of col  (Read 2590 times)

jButtkus

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
  • keep on smurfin'
    • View Profile
Probs or Bug /w FKs referencing  group of col
« on: January 12, 2006, 03:16:47 am »
Hi!

I have a Problem within the generated ddl code when it comes to foreign keys referencing a group of columns
(here's an example):



As you can see, I want to create a foreign key relationsship
for sonID and fatherID, each referencing the columngroup
(maleID, familyID). So here it is for the father FK:

Up to here everything seems fine.
But when I generate the ddl code I get this result:
-----------------------------
ALTER TABLE isFatherOf ADD CONSTRAINT FK_isFatherOf_maleMembersOfFamily_father

FOREIGN KEY (fatherID, familyID) REFERENCES maleMembersOfFamily (, familyID)
;
------------------------------

But instead it should be
-----------------------------
ALTER TABLE isFatherOf ADD CONSTRAINT FK_isFatherOf_maleMembersOfFamily_father

FOREIGN KEY (fatherID, familyID) REFERENCES maleMembersOfFamily (maleID, familyID)
;
------------------------------
Is it up to me, do I anything wrong, or does it seem to be a bug of EA?
(btw I'm using Program version 6.0.781)

thanks ahead

   joshua

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Probs or Bug /w FKs referencing  group of
« Reply #1 on: January 22, 2006, 03:04:45 pm »
Try the latest build 6.1.785.  :)

jButtkus

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
  • keep on smurfin'
    • View Profile
Re: Probs or Bug /w FKs referencing  group of
« Reply #2 on: January 23, 2006, 03:35:26 am »
Cool it works! The problem with the lost foreign keys seems also to be vanished. ( I also had the problem that not all
fk's has been generated, and I forgot to tell about this)  ::)

Thanks alot ;-)

   Joshua