[dba-issues] [Issue 89456] Relationships tool should allow the creation self referencing relations
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 Status|VERIFIED |CLOSED --- Additional comments from atjen...@openoffice.org Mon May 4 03:25:38 + 2009 --- Tested w/ OO.o 3.1 RC2, XP Closing - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 89456] Relationships tool should allow the creation self referencing relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89456 --- Additional comments from vladimir_hiteksch...@openoffice.org Sun Apr 19 18:31:50 + 2009 --- Issue 89456 has been fixed in master version OOo-dev 3.1 .0 (OOO310m9 Build:9396) for Windows XP and can be closed. - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 89456] Relationships tool should allow the creation self referencing relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89456 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from [EMAIL PROTECTED] Tue Aug 19 11:52:30 + 2008 --- Please verify. Thanks. - 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]
[dba-issues] [Issue 89456] Relationships tool should allow the creation self referencing relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89456 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED Target milestone|OOo 3.x |OOo 3.1 --- Additional comments from [EMAIL PROTECTED] Wed Aug 13 13:13:25 + 2008 --- Fixed in cws dba31b - 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]
[dba-issues] [Issue 89456] Relationships tool should allow the creation self referencing relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89456 User fs changed the following: What|Old value |New value Assigned to|requirements |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Target milestone|--- |OOo 3.x --- Additional comments from [EMAIL PROTECTED] Mon Jul 28 12:12:20 + 2008 --- assigning to developer - 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]
[dba-issues] [Issue 89456] Relationships tool should allow the creation self referencing relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89456 User digulla changed the following: What|Old value |New value CC|'atjensen,khirano,r4zoli' |'atjensen,digulla,khirano, | |r4zoli' - 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]
[dba-issues] [Issue 89456] Relationships tool should allow the creation self referencing relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89456 User khirano changed the following: What|Old value |New value CC|'atjensen,r4zoli' |'atjensen,khirano,r4zoli' - 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]
[dba-issues] [Issue 89456] Relationships tool should allow the creation self referencing relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89456 --- Additional comments from [EMAIL PROTECTED] Sun Jul 27 20:32:57 + 2008 --- *** Issue 92188 has been marked as a duplicate of this issue. *** - 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]
[dba-issues] [Issue 89456] Relationships tool should allow the creation self referencing relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89456 User r4zoli changed the following: What|Old value |New value CC|'atjensen'|'atjensen,r4zoli' - 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]
[dba-issues] [Issue 89456] Relationships tool should allow the creation self referencing relations
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 +
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]
