You can't change the foreign key because it is a "copy" of another attribute that has
migrated down a relationship. If you want to change the properties, then you change
the source attribute and the foreign key will be updated to match. If you were
allowed to change the domain of a foreign key attribute, you would, in essence, be
destroying the referential integrity of the database.
Regards,
Walter
WallStreet Consulting Services, Inc.
[EMAIL PROTECTED]
"Managing Your Data Investment"
>>> "Mara Lascu" <[EMAIL PROTECTED]> 06/18/00 07:46AM >>>
Is there any possibility to alter the characteristics of a field once it
becomes part of the foreign key? I've noticed that the type and all
constraints are the ones of the primary key, including NOT NULL constarint.
In oracle a FK might be null without violating FK constraint, but apparently
Rose doesn't allow changes on a field if it is part of a FK.
Thank you,
Mara Lascu
************************************************************************
* 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
*
*************************************************************************
************************************************************************
* 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
*
*************************************************************************
