Book a Demo

Author Topic: Can't open the 'Foreign Key Constraint' menu item  (Read 8038 times)

Pritish

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Can't open the 'Foreign Key Constraint' menu item
« on: April 29, 2010, 04:59:14 am »
Hello,

I'm relatively new to EA. I was having problems creating the foreign key constraint between 2 tables for data modelling. I tried to follow the exact direction posted on the foll: HELP page

http://www.sparxsystems.com/uml_tool_guide/data_modeling/create_a_foreign_key.htm


But doesn't quite help matters.

I'm not able to right-click on the connector, to pop up that 'Foreign Key Constraint' menu item. In fact, even when I right click on any of the tables, I see a standard list of options (that includes options like other, package, class, interface etc. popping up, which is different from the actual of options when I use the keyboard to right-click.)

Basically, when I right-click in the main diagram area of the data model, I see the same list of options(irrespective of if I've clicked on a connector or a table)
Can anyone point out what I'm doing wrong. I've even tried re-installing EA, but doesn't help matters.

Is there another way to implement the FK constraint ?

Thanks,
Pritish.

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Can't open the 'Foreign Key Constraint' menu i
« Reply #1 on: April 29, 2010, 08:21:59 am »
Maybe you only have the Desktop Edition of EA. You need at least the Professional Edition for data modeling.

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Can't open the 'Foreign Key Constraint' menu i
« Reply #2 on: April 29, 2010, 10:01:10 am »
Hi Pritish,

Are you saying that depending on whether you use the mouse or the keyboard to bring up the context menu, you get different menus?

If so, then I'd look elsewhere for the problem.  I don't think EA would be "mucking about" with such fundamental O/S functionality.

What version/edition of EA are you using?  What O/S?

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Nizam Mohamed

  • EA User
  • **
  • Posts: 193
  • Karma: +1/-0
    • View Profile
Re: Can't open the 'Foreign Key Constraint' menu i
« Reply #3 on: April 29, 2010, 04:03:52 pm »
Quote
In fact, even when I right click on any of the tables, I see a standard list of options (that includes options like other, package, class, interface etc. popping up, which is different from the actual of options when I use the keyboard to right-click.)

you are talking about "toolbox" menu being displayed, this can happen in one of the following circumstances.
  • pressing "Ctrl" button when pressing keyboard right click
  • holding "Shift" button during mouse right click
  • clicking both right and left mouse buttons at same time.
To display the element or connectors' contextmenu, try either just mouse right click or keyboard right click(check if you are not pressing Ctrl button accidentally!)



Pritish

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Can't open the 'Foreign Key Constraint' menu i
« Reply #4 on: April 30, 2010, 12:35:48 am »
I'm using the EA 8.0 Professional Edition on Win XP Professional SP3.
I'm not holding the CTRL or the SHIFT key nor am I pressing both keys together when I right-click on any object in the diagram area.

The main problem, if I haven't clearly explained it, is I cannot right-click in the diagram area of the data model.

Therefore, I was hoping to know if there an alternative way to implemenet the Foreign Key constraint between 2 tables (other then the one mentioned on the Help page, as it onvolved right-clicking on the connector)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Can't open the 'Foreign Key Constraint' menu i
« Reply #5 on: April 30, 2010, 09:42:27 am »
Hi Pritish,

Again, if you can't right-click on the diagram then there's something else going on...

A year or so ago, I had something similar.  It turned out Google Desktop (IIRC) was "stealing" certain keystrokes.  So check out any other programs that react to global stuff and perhaps disable them for a period.

HTH,
Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Can't open the 'Foreign Key Constraint' menu i
« Reply #6 on: April 30, 2010, 04:02:17 pm »
Or by a new mouse if the right click button is broken ;D

Geert

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Can't open the 'Foreign Key Constraint' menu i
« Reply #7 on: April 30, 2010, 04:09:50 pm »
Quote
Or by a new mouse if the right click button is broken ;D

Geert
"You might well think that.  I couldn't possibly say that..."

 ;)

Quote from an excellent BBC series "House of Cards".

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Pritish

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Can't open the 'Foreign Key Constraint' menu i
« Reply #8 on: May 04, 2010, 01:58:22 am »
Hi Paolo,

I don't really have Google Desktop installed on my machine, nor do have any other application, which might be possible of stealing keystrokes.

Is there another way to create the Foreign Key Constraint though?
Pretty sure there must be an alternative solution.

Please help.

Thanks,
Pritish.

RoyC

  • EA Administrator
  • EA Practitioner
  • *****
  • Posts: 1297
  • Karma: +21/-4
  • Read The Help!
    • View Profile
Re: Can't open the 'Foreign Key Constraint' menu i
« Reply #9 on: May 04, 2010, 02:31:55 pm »
Pritish

Have you submitted a bug report for this problem? Use the Report a Bug link in the Support column at the bottom of this page.

The user base probably can't help you here (if Geert and Paolo can't help, that's the end of it!) so get Sparx Support to have a look (via the bug report).
« Last Edit: May 04, 2010, 02:48:55 pm by RoyC »
Best Regards, Roy

Pritish

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Can't open the 'Foreign Key Constraint' menu i
« Reply #10 on: May 05, 2010, 02:52:08 am »
Alright.

Thanks Roy.

I've reported this as a bug.