[dba-issues] [Issue 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from vladimir_hiteksch...@openoffice.org Wed Apr 8 07:13:23 + 2009 --- As to Issue 92782 problems still exist. I considered second attached document (i92782.odb). When using drag and drop for creating relations: 1.'n', showing one-to-many on second relation is missing (see attachment i92782_1), 2.after saving and reopening relationships, only the first relation appears, but second is lost. While using 'Insert-New Relation' trying to create two relations simultaneously causes error (see attachment i92782_2). And when creating two relations separately using 'Insert-New Relation' twice everything is 'OK' - after saving and reopening relationships both relations exist and one-to-many attributes '1 - n' appears. - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from vladimir_hiteksch...@openoffice.org Wed Apr 8 07:14:21 + 2009 --- I consider master version OOo-dev 3.1 .0 (OOO310m9 Build:9396) for Windows XP . - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from vladimir_hiteksch...@openoffice.org Wed Apr 8 07:15:45 + 2009 --- Created an attachment (id=61447) 'n' is missed while creation relation by drag and drop - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from vladimir_hiteksch...@openoffice.org Wed Apr 8 07:17:04 + 2009 --- Created an attachment (id=61448) error while creating two relations simultaneously - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 User fs changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Wed Dec 3 08:53:17 + 2008 --- looks good in CWS dba31d - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from [EMAIL PROTECTED] Wed Dec 3 08:54:34 + 2008 --- fs-gld199: Once the CWS dba31d is integrated (you can monitor this here: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba31d), and a new developer snapshot becomes available containing the fix, I encourage you to verify your problems are fixed indeed. I think they are, but since this issue has a ... complex history, I like to be sure ... 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from [EMAIL PROTECTED] Wed Nov 19 12:34:36 + 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 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] Fri Nov 7 11:15:21 + 2008 --- Fixed in cws dba31d while fixing issue 93474 - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from [EMAIL PROTECTED] Sun Aug 24 12:54:51 + 2008 --- FYI - assuming I am following this correctly. Using OOO300 m_3 under Linux today I can do all that is described and have it saved WHEN I use the mouse to drag and drop the fields to the tables in the relation designer. It is only when I call the relation dialog from the menu that the new relations seem to be lost. - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from [EMAIL PROTECTED] Sun Aug 24 21:13:57 + 2008 --- atjensen, I see what you mean. I can actually get it to work one way now you've pointed it out. The following all use fs's attachment. Works: - open the document - Tools / Relationships ... - click on ID in the Right table, drag and drop to ID2 in the Left table - in the dialogue This relation already exists, select Create... = relations dialogue appears - check that the pre-filled fields are correct (ID2-Left and ID-Right) - close the relations dialogue with OK = both relationships are shown - save - close the Relationships window - Tools / Relationships ... = both relationships are still shown Doesn't work (1) (fs's example) - open the document - Tools / Relationships ... - Insert / New Relation ... - in the Relations dialog - set Tables involved to left and right - set Fields involved to ID1-ID and ID2-ID, this way creating one relation between left and right, which connects left.ID1 with right.ID and left.ID2 with right.ID. - close the Relations dialog with OK = the new relation appears in the relation design - save and close the relation design - Tools / Relationships = the newly created relation is gone Doesn't work (2) - open the document - Tools / Relationships ... either: - click on ID in the Right table, drag and drop to ID2 in the Left table - in the dialogue This relation already exists, select Edit... or: - right-click on the line representing the existing relationship - select Edit then: = relations dialogue appears = notice that the pre-filled fields show the existing relationship (ID1-Left and ID-Right) - on the line underneath the existing relationship select ID2-Left and ID-Right - close the relations dialogue with OK = the new relation appears in the relation design = notice that the Save icon is still greyed out, as is Save in the File menu - close without saving = NO prompt The relationship design has been changed. Do you want to save the changes? = new relationship is lost Doesn't work (3) (same as fs's example but first deleting pre-existing relationship to start with a clean slate) - open the document - Tools / Relationships ... - right-click the existing relationship line - select Delete = no relationships show - Insert / New Relation - in the Relations dialogue - set Tables involved to left and right - set Fields involved to ID1-ID and ID2-ID, this way creating one relation between left and right, which connects left.ID1 with right.ID and left.ID2 with right.ID. - close the Relations dialog with OK = the new relation appears in the relation design (two lines join tables) - save and close the relation design - Tools / Relationships = the newly created relation is gone (no lines join tables: i.e. I had imagined it was saving the first listed relationship and discarding the second, but when two brand new relationships are added together in this way, neither is saved) --- I have a feeling I have mixed up the terminology again wrt - one relationship of two parts between two tables - two separate relationships between two tables ... but I hope I made myself understood anyway? - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from [EMAIL PROTECTED] Fri Aug 22 08:58:20 + 2008 --- Okay, I see multiple problems here. For one, we seem to have a problem with terminology, then there are multiple bugs in our relation designer UI. I will submit separate issues for separate bugs. First, for the terminology. There's a difference between having *two* relationships between two given tables, each including *one* field from every table, and having *one* relationship between the two tables, which includes *two* fields from every table. For instance, consider the tables 2-in-1s and Anthologies in the bugdoc database. Both have fields called 1AuthorID and 2AuthorID. We could set up two different scenarios: - *one* relationship: We could create a single relationship, which connects 1AuthorID from 2-in-1s with 1AuthorID from Anthologies, *plus* connects 2AuthorID from 2-in-1s with 2AuthorID from Anthologies. - *two* relationships We could create *one* relationship which connects the two 1AuthorID fields, and *another* which connects the two 2AuthorID fields. (Let's not talk about how senseless such relationships might be, this is just an example here). Technically, both scenarios are different, and this is important to understand. Unfortunately, the UI makes it easy to get confused, plus the aforementioned bugs ... I will go to submit the different sub-bugs I found, and then proceed with this issue here. - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from [EMAIL PROTECTED] Fri Aug 22 09:34:12 + 2008 --- Ah ... now that I played more with it ... I planned to submit all follow-up issues separately, and ask here whether they address this problem here adequately. Simply because I was not sure I understood the problem in this issue here completely. However, I think I found what the original submitter means. Going to attach a simplified bug doc with a step-by-step description. - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from [EMAIL PROTECTED] Fri Aug 22 09:35:10 + 2008 --- Created an attachment (id=55941) document to reproduce the bug case - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 User fs changed the following: What|Old value |New value Assigned to|fs|oj --- Additional comments from [EMAIL PROTECTED] Fri Aug 22 09:38:12 + 2008 --- here's how to reproduce the problem with the second attached document (i92782.odb): - open the document - Tools / Relationships ... - Insert / New Relation ... - in the Relations dialog - set Tables involved to left and right - set Fields involved to ID1-ID and ID2-ID, this way creating one relation between left and right, which connects left.ID1 with right.ID and left.ID2 with right.ID. - close the Relations dialog with OK = the new relation appears in the relation design - save and close the relation design - Tools / Relationships = the newly created relation is gone - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from [EMAIL PROTECTED] Fri Aug 22 09:40:05 + 2008 --- For completeness: - I also submitted issue 93020, since I think the effect described therein also contributes to the confusion between one relation with 2 fields and two relations with one field. - With another database setup, I was actually able to create multiple relations between two tables, I am uncertain what is so special about the given sample database(s) that it doesn't work there - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from [EMAIL PROTECTED] Fri Aug 22 19:58:22 + 2008 --- fs, thank you very much for the work you're putting in here. I will re-read your explanations a few times and play with your test docs too to see if I can *get* the way you've split the issue apart. I've never used database software before the week I spent playing with Base, so I only half understand what it's for and what it should be able to do. (As you might be able to tell!) I am still in awe of the fact that Open Source software exists and just how many people have come together to make this all happen. - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 User clu changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |fs --- Additional comments from [EMAIL PROTECTED] Wed Aug 20 11:58:03 + 2008 --- clu-fs: like we have spoken, this is a mismached behavior and has to be fixed in any way .. so i confirm 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 User clu changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW OS/Version|Windows Vista |All Target milestone|--- |OOo 3.x --- Additional comments from [EMAIL PROTECTED] Wed Aug 20 11:59:20 + 2008 --- set to 'new' - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from [EMAIL PROTECTED] Thu Aug 14 14:57:24 + 2008 --- Using the test doc I am unable to reproduce this problem HOWEVER this is using XP here - so perhaps this is a Vista only problem. - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 Issue #|92782 Summary|can set multiple relationships between two tables but |only one is actually saved Component|Database access Version|OOo 2.4.1 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|gld199 --- Additional comments from [EMAIL PROTECTED] Wed Aug 13 22:56:35 + 2008 --- I have a database with several tables. If I go to Tools--Relationships, I can set single (1-n) relationships between tables with no issues. I can (since upgrading from 2.3 to 2.4) set multiple 1 to many relationships (either through trying to drag and drop a second relationship, clicking edit on the resulting error dialogue box; or by double clicking the relationships line). I can get multiple relationships to appear (I see a new line for each new relationship), however when I save and exit Relationships it discards all but the first listed relationship between any two tables. Even immediately after setting up these multiple relationships, I am able to add invalid data into all but one field in my table without getting an error message. Sure enough, if I go back into Relationships, all the extra lines have disappeared and only one relationship per pair of tables is listed in the Relations editing window. [I can't see how to add an attachment otherwise I'd upload an example. I don't know what the difference is between OOo 2.4.1/RC1/RC2] - 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 92782] can set multiple relations hips between two tables but only one is actual ly saved
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92782 --- Additional comments from [EMAIL PROTECTED] Wed Aug 13 22:58:42 + 2008 --- Created an attachment (id=55758) only one 1-n relationship can actually be saved between two tables - 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]