[7.1] Cannot name a view in Data Model

[Emilio]

When you choose to add a View object to a data model (Extended | Data Modeling) you are shown a dialog that has a dropdown box with the database product (Oracle, SQL Server 2005, etc.) and a large textbox where one writes the actual SQL query of the view. You cannot name it, you cannot add constraints, you cannot view properties because the property dialog is only DB type and Query.

The problem is... this dialog does not allow you to NAME the view so it remains as "Class1" with View stereotype. The only way to give it the proper name is to go to the Project Browser and rename it there.

The view dialog must contain a textbox so that the user can name the view. It would also be nice if you can also add constraints which can be used for example to specify GRANT/DENY permissions.

[«Midnight»]

No problem Emilio,

Highlight the name of the view on the diagram. To do this select the view by clicking (not double clicking) it. Then click again on top of the name. You can then either type a new name. If this does not work, press F2 when the name is highlighted to turn the name into an edit box. Pressing return or clicking elsewhere ends the edit.

This is documented in the EA help on Views, but it is easy to miss if you are not used to EA's in-place editing paradigm.

[edit]Note that this will work for a view name, but will not help you if you want to add an alias.

I just tested another method that works fine for both. Open the EA Properties window (not the dialog). You can toggle this window on and off with Alt-1, or through the View menu. It may also be docked in a window group on your desktop layout.

When you highlight the view you can use the Properties window - once again, not the dialog - to edit the name or add an alias.[/edit]

HTH, David

[Emilio]

Thanks "Midnight" that is indeed another way which I knew about but seldom use, I guess that is why I missed it too.

However, from the standpoint of a user I look for uniformity in behaviour.

[«Midnight»]

...
However, from the standpoint of a user I look for uniformity in behaviour.

Couldn't agree more.

[Paolo F Cantoni]

...
However, from the standpoint of a user I look for uniformity in behaviour.

Couldn't agree more.

The dreaded "C" word...  

Paolo

[«Midnight»]

Paolo,

You got the message loud and clear. Why am I not surprised?

David

[Paolo F Cantoni]

Paolo,

You got the message loud and clear. Why am I not surprised?

David

You'll notice I'm not even spelling out the complete word...

Soon it will be: "the concept that dare NOT speak its name"...  

Paolo

[«Midnight»]