[dba-issues] [Issue 112126] Query wizard doesn't keep table relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112126 --- Additional comments from r4z...@openoffice.org Mon Jun 7 08:39:41 + 2010 --- If you read the Base Query wizard help text it is says about one table as source of query. In the main time you can select more than one table as source in wizards first step. Some words in help can be useful, about consequence of selecting more than one table. But best place for it in Base Guide. It can be an enhancement to modify query wizard to recognize existing relations. - 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 112126] Query wizard doesn't keep table relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112126 --- Additional comments from briss...@openoffice.org Mon Jun 7 00:00:00 + 2010 --- Created an attachment (id=69842) Example base with two queries - 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 112126] Query wizard doesn't keep table relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112126 --- Additional comments from briss...@openoffice.org Mon Jun 7 00:04:37 + 2010 --- @r4zoli What you means under: it doesn't work, please describe in more details. A mean that query neither shows relation nor gives a proper SQL statement. I attached an example base. You'll find 2 queries, one made with wizard, the other in design query view. As you can see with wizard you get a SQL statement that doesn't take into account relation between tables, so you get a kind of Cartesian product of two tables and not a more logical query. - 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 112126] Query wizard doesn't keep table relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112126 User atjensen changed the following: What|Old value |New value CC|'r4zoli' |'atjensen,r4zoli' --- Additional comments from atjen...@openoffice.org Mon Jun 7 00:10:41 + 2010 --- I don't believe this has ever been supported in the Query wizard - ? Seems like a valid enhancement request. - 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 112126] Query wizard doesn't keep table relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112126 User r4zoli changed the following: What|Old value |New value CC|''|'r4zoli' Keywords| |needmoreinfo, oooqa --- Additional comments from r4z...@openoffice.org Sat Jun 5 11:41:17 + 2010 --- @Brissels That query involves two linked tables, it doesn't work. What you means under: it doesn't work, please describe in more details. Can you upload an example file, without sensitive data? I checked in DEV300m80(win7 and ubuntu 10.04) and found, if I add two tables, connected in 1-n relations(checked only this), relations not shown in query created with wizard. If I add new table in design view, and the new table have relation to one of the existing in query table, the relation is show to newly added table. But relations between two existing tables not changes. The query runs and show all data. - 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 112126] Query wizard doesn't keep table relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112126 Issue #|112126 Summary|Query wizard doesn't keep table relations Component|Database access Version|OOO310m10 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|brissels --- Additional comments from briss...@openoffice.org Fri Jun 4 17:54:01 + 2010 --- I tried to make a query using the wizard. That query involves two linked tables, it doesn't work. In design view I found that relation is not displayed. In design view if I add a new table, relation are displayed correctly. So wizard may be the problem. I found it in 3.0 and 3.1 ubuntu builts. - 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 112126] Query wizard doesn't keep table relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112126 --- Additional comments from briss...@openoffice.org Fri Jun 4 17:55:19 + 2010 --- Created an attachment (id=69804) Query design view - 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
