To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=89456
User atjensen changed the following:
What |Old value |New value
================================================================================
CC|'' |'atjensen'
--------------------------------------------------------------------------------
Assigned to|dbaneedsconfirm |requirements
--------------------------------------------------------------------------------
Issue type|DEFECT |ENHANCEMENT
--------------------------------------------------------------------------------
Summary|Relationships tool can't c|Relationships tool should
|reate self relations |allow the creation self re
| |ferencing relations
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed May 14 22:28:10 +0000
2008 -------
It is not correct to say that you can not have this type of self-referencing
foreign key in Base. It is true that you can not create it using the GUI
relationship designer window.
Given your example the foreign key would be added by doing the following:
Open the SQL window ( Tools>SQL )
Enter the ALTER TABLE command to add the FK
ALTER TABLE "CATEGORY"
ADD FOREIGN KEY ("PARENT_ID")
REFERENCES "CATEGORY" ("ID")
Click on execute.
The database engine will now enforce the foreign key - but the GUI designer will
not display it.
I am changing your issue then from a defect to a Request for Enhancement,
altering the summary appropriately and forwarding it to the requirements.
For example: It could be changed so that this type of FK could be added using
the Add Realtion dialog from the relationship designer. This would require only,
I would guess, that the drop downs for the tables allow the same table to be
included on both sides of the relation.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
