[dba-issues] [Issue 105737] Unable to Define Relation ships in tables
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105737 User mechtilde changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from mechti...@openoffice.org Tue Nov 24 15:53:04 + 2009 --- invalid -> 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 105737] Unable to Define Relation ships in tables
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105737 User atjensen changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from atjen...@openoffice.org Fri Oct 9 17:35:50 + 2009 --- @Kevin - Thanks. Well, I see the problem and it is perhaps a misunderstanding of how the FK relationships work and/or what the purpose of them is. As the issue tracking system is not the place to handle support, PLEASE either subscribe to and send an email to the use...@dba.openoffice.org mailing list or come by the web forum at http://user.services.openoffice.org/en/forum (if you do the web forum go ahead and send me a PM there) and I know that folks will help you work this out. Marking this issue as INVALID. - 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 105737] Unable to Define Relation ships in tables
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105737 --- Additional comments from kevin_trai...@openoffice.org Fri Oct 9 08:52:44 + 2009 --- Created an attachment (id=65260) Associated tables producing error for issue 105737 - 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 105737] Unable to Define Relation ships in tables
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105737 --- Additional comments from atjen...@openoffice.org Thu Oct 8 18:53:03 + 2009 --- @kevin_trainer - I am unable to duplicate this error using OO.o 3.1.1 and XP (I don't have a copy of NT ). Any possibility you could attach your database, minus any data, to the issue and I'll try with the actual file. - 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 105737] Unable to Define Relation ships in tables
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=105737
Issue #|105737
Summary|Unable to Define Relationships in tables
Component|Database access
Version|OOo 3.1
Platform|PC
URL|
OS/Version|Windows NT
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P2
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|kevin_trainer
--- Additional comments from kevin_trai...@openoffice.org Thu Oct 8
16:00:29 + 2009 ---
1. Created 2 tables (Customers & Title) both with primary keys
2. Selected Tools > Relationships...
3. Added both tables(Customers & Title)
4. Attempted to associate the tables using the Title fields from both the
tables, so as to create a lookup/association
5. I tried this a number of times using different methods (draging from one to
the other and using the New Relationships dialog)
All result in the following errors:
OpenOffice.org Base
Primary or unique constraint required on main table: "Customers" in statement
[ALTER TABLE "Title" AND FOREIGN KEY ("Title") REFERENCES "Customers" ("Title")]
OR
OpenOffice.org Base
Primary or unique constraint required on main table: "Title" in statement
[ALTER TABLE "Customers" AND FOREIGN KEY ("Title") REFERENCES "Title" ("Title")
ON UPDATE CASCADE ON DELETE CASCADE]
-
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
