Author Topic: Issue with Foreign Keys  (Read 2119 times)

bmains

  • EA Novice
  • *
  • Posts: 19
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Issue with Foreign Keys
« on: December 19, 2007, 07:06:42 am »
Hello,

I'm using EA 6.5, and I get this situation now and then when I'm using foreign keys:

I create an association between tables, and I'll then select the foreign key dialog and create the key by selecting the key field in both tables.

For some reason, later I get a situation where it drops the key field on one side of the relationship, but it exists on the other side.  I try reselecting both fields and click save.  It ignores this action.  I try deleting the field on the one side from the relationship, no action.

The only thing that works is deleting the relationship and redrawing it.  But I can't just delete the connector.  I have to delete the connector, then delete the relationship in the table.

Is there an easier way to fix this issue?  And, why does this happen?  I didn't rename any fields, but I know I did rename the table.  And, it doesn't happen for every relationship in the table I rename...

Thanks.

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Re: Issue with Foreign Keys
« Reply #1 on: December 19, 2007, 02:34:10 pm »
AFAIK it works as you describe also in 7.0. Why? EAUI...
Recursion definition:
If you don’t understand the definition read "Recursion definition".

bmains

  • EA Novice
  • *
  • Posts: 19
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: Issue with Foreign Keys
« Reply #2 on: December 28, 2007, 10:40:27 am »
Hello,

The other issue I'm experiencing is that I rename a foreign key in the Operations editor popup window but it doesn't rename it in the treeview.  It still has the old name in the project browser.

Closing/reopening fixes this, but it would be nice if that did work.  And, when I click on the old name, it does show the new name in the operations editor, but still has the old name in the project browser.

Thanks.

bmains

  • EA Novice
  • *
  • Posts: 19
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: Issue with Foreign Keys
« Reply #3 on: December 28, 2007, 10:45:57 am »
A correction: when double-clicking the foreign key in the data model, rename, and save, it does seem to be updating the project browser...

But when double-clicking a relationship in the project browser, or by right-clicking the table and selecting operations, and changing the name this way, it doesn't take.

But the weird thing is it seems to be one step behind of the changes, and certain interactions I'm doing does update it.  For instance, I change a name from PK_A to PK_AAA in the data model, and it works.  I change it from PK_AAA to PK_B, it doesn't work (still shows PK_AAA).

But something I'm doing is causing it to work because it eventually shows PK_B, but I'll change it to something else in the project browser and it still shows PK_B. I can't explain exactly what is happening, but it's definitely a bug...

Thanks.