Here the answers:
1. If you have two relationships, you have to manually "bend" on on the
diagram, as they overlap. Click it in the middle and drag to the side.
2. Renaming a primary key comlumn does not change the foreign key names, as
they are on they own. The references are however changed. We do not rename
it, as this would in most cases mean a huge change in all of the database
access methods. You can write a short script to do it.
Davor
-----Original Message-----
From: Walter Howard
To: [EMAIL PROTECTED]
Sent: 4/3/2001 9:11 AM
Subject: Re: (ROSE) Name space Conflicts in data modeler
One interesting caveat to this scenario. If I have two relationships
between two tables, the second foreign key is ignored when updating the
primary key column name. Additionally, I can't even get the second
relationship line to show up on the data model diagram.
Walter
WallStreet Consulting Services, Inc.
"Managing Your Data Investment"
>>> "Patrick Kennedy" <[EMAIL PROTECTED]> 04/02/01 06:40PM >>>
>From the desription of the problem I'm guessing you are
manually adding the FK column from the parent into the
child. Basically this is a "don't do that". When you
have a PK and create a relation to a table, Rose will
automatically create a copy of the PK column(s) in the child.
i.e.
If I have two tables,
Parent
col_1 PK
Child
col_2 PK
then draw a relation between the two, I should wind up with,
Parent
col_1 PK
Child
col_2 PK
col_1 FK
So if you rename the PK in the parent, then it should also
get updated in the child.
The error about "name space conflict" means you are trying to
create two columns with the same name in the same table.
Since the PK is automatically copied down, if you try to
make it directly you can run into this sort of problem.
Patrick Kennedy
Rational Support
On Apr 2, 17:35, Naushaba Mumtaz wrote:
> Subject: (ROSE) Name space Conflicts in data modeler
>
> I have transformed a class diagram into data model using the Rose data
modeler add-in. I am coming up against 2 problems:
>
> 1. When I change the name of a P.K. attribute, the name change is not
carried
over into the other tables (e.g. where the attribute is a F.K. also). Is
there
a way to fix this?
>
> 2. Another error message I run into while changing the names of
certain
attributes is 'Changing the name of this value would create a name space
conflict'. Why is this so and how shall I fix it?
>
> Thanks in advance.
>
> Abby
>
> __________________________________________________________________
> Get your own FREE, personal Netscape Webmail account today at
http://webmail.netscape.com/ <http://webmail.netscape.com/>
>
************************************************************************
> * Rose Forum is a public venue for ideas and discussions.
> * For technical support, visit http://www.rational.com/support
<http://www.rational.com/support>
> *
> * Admin.Subscription Requests: [EMAIL PROTECTED]
> * Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
<http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl>
> * Other Requests: [EMAIL PROTECTED]
> *
> * To unsubscribe from the list, please send email
> *
> * To: [EMAIL PROTECTED]
> * Subject:<BLANK>
> * Body: unsubscribe rose_forum
> *
>
************************************************************************
*
>-- End of excerpt from Naushaba Mumtaz
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
<http://www.rational.com/support>
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
<http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl>
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
************************************************************************
*
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
