[dba-issues] [Issue 102793] Ambigouos ColumnNaming in Subform WHERE clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102793 User oj changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from o...@openoffice.org Thu Dec 2 13:26:53 + 2010 --- One year past. I'm closing this one. - 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 102793] Ambigouos ColumnNaming in Subform WHERE clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102793 User oj changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from o...@openoffice.org Thu Dec 2 13:27:18 + 2010 --- . - 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 102793] Ambigouos ColumnNaming in Subform WHERE clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102793 --- Additional comments from f...@openoffice.org Wed Sep 30 18:20:18 + 2009 --- fs-sos: ping. As Marc suggested, is it okay for you to close the issue as WORKSFORME? - 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 102793] Ambigouos ColumnNaming in Subform WHERE clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102793 --- Additional comments from m...@openoffice.org Tue Aug 18 06:39:58 + 2009 --- msc - sos: So you can't reproduce this anymore, right? Then we can close this issue as WORKSFORME. Is this OK for you? Bye Marc - 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 102793] Ambigouos ColumnNaming in Subform WHERE clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102793 --- Additional comments from f...@openoffice.org Mon Jul 6 07:48:53 + 2009 --- fs-sos: Uhm, being able to read is an advantage, certainly :) Sorry. Okay, let me ask for the result of a mysqldump --no-data --database db table_1 ... table_n then (The syntax is out of my head right now, and thus probably wrong, but you get the idea). Again, having an easy method to reproduce *exactly* your problem (and not something which might look like your problem) increases your chances. An SQL script to re-create the table structure is such an easy method. - 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 102793] Ambigouos ColumnNaming in Subform WHERE clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102793 --- Additional comments from s...@openoffice.org Mon Jul 6 09:55:18 + 2009 --- sos- I know a dump is easy to make, but I can not reproduce this error myself. I had 3 forms based on SQL statements and have in all Three a column named parent.The SQL statement who replicate the master-slave relation not always use the DBasename.TabeleName.ColumnName combination to identify a culumn in the SQL statement. So my column parent was ambigouos. This bug must been related to the problems you sloved already for the filters placed on a form. Sorry, in the future I will make a dump and a copy of all the SQL in volved - 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 102793] Ambigouos ColumnNaming in Subform WHERE clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102793 --- Additional comments from s...@openoffice.org Fri Jul 3 07:11:25 + 2009 --- sos-fs Frank as i mentioned in my first comment: This problem occurs only when using a connection to a External database in my case a ODBC or Native connection to a MySQL database :=) - 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 102793] Ambigouos ColumnNaming in Subform WHERE clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102793 --- Additional comments from f...@openoffice.org Thu Jul 2 19:14:02 + 2009 --- fs-sos: Would it be possible for you to re-create the problem in a self-contained HSQLDB, which you can attach here for reference? This would tremendously ease the future handling of the bug, if everybody involved just needs to open this doc to easily reproduce the 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: 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 102793] Ambigouos ColumnNaming in Subform WHERE clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102793 --- Additional comments from f...@openoffice.org Thu Jul 2 19:15:06 + 2009 --- and, well, such a one-click-reproducibility would also tremendously increase the chances of somebody having the time to confirm/assign/target (and thus finally fix) the bug - 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 102793] Ambigouos ColumnNaming in Subform WHERE clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102793 Issue #|102793 Summary|Ambigouos ColumnNaming in Subform WHERE clause Component|Database access Version|OOO310m9 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|fs Reported by|sos --- Additional comments from s...@openoffice.org Mon Jun 15 12:26:04 + 2009 --- This problem occurs only when using a connection to a External database in my case a ODBC or Native connection to a MySQL database. When defining a subform There is something wrong with the SQL-translation behind de Matster and Slave fields definitions who are in the background translated to a WHERE clause Thise clause contains culumnNaming without the TableName and thats produce a error. as I can not gives a sample Document, i gives the user-made SELECT clause and the system-made WHERE clause SELECT `tbl_vkp_parents`.`parent`, `tbl_leveranciers_copy`.`KLNR`, `tbl_leveranciers_copy`.`toestand`, `tbl_leveranciers_copy`.`Uithangbord`, `tbl_leveranciers_copy`.`Firma`, `tbl_leveranciers_copy`.`Aanspreking` FROM `tbl_vkp_parents` AS `tbl_vkp_parents`, `tbl_leveranciers_copy` AS `tbl_leveranciers_copy` WHERE `tbl_vkp_parents`.`klnr` = `tbl_leveranciers_copy`.`KLNR` SELECT `tbl_vkp_parents`.`parent`, `tbl_leveranciers_copy`.`KLNR`, `tbl_leveranciers_copy`.`toestand`, `tbl_leveranciers_copy`.`Uithangbord`, `tbl_leveranciers_copy`.`Firma`, `tbl_leveranciers_copy`.`Aanspreking` FROM `tbl_vkp_parents` AS `tbl_vkp_parents`, `tbl_leveranciers_copy` AS `tbl_leveranciers_copy` WHERE ( ( `tbl_vkp_parents`.`klnr` = `tbl_leveranciers_copy`.`KLNR` ) AND ( ( `parent` = :link_from_parent ) ) ) AND ( 0 = 1 ) I supose AND ( ( `parent` = must be AND ( ( `tbl_vkp_parents`.`parent` = There is NO Workaround: - Using a Alias Column names is not working: The UI alows entering the Alias ColumnNames but gives a error saying the Alias names are not found as ColumnNames. - Using a Query as Source for the SubForm leads to the same error's - 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 102793] Ambigouos ColumnNaming in Subform WHERE clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102793 User fs changed the following: What|Old value |New value Assigned to|fs|dbaneedsconfirm --- Additional comments from f...@openoffice.org Mon Jun 15 12:30:42 + 2009 --- dbaneedsconfirm is the pool for issues which need to pass confirmation. Sorry, but I feel unable to handle all incoming issues myself ;) - 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 102793] Ambigouos ColumnNaming in Subform WHERE clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102793 --- Additional comments from s...@openoffice.org Mon Jun 15 12:47:46 + 2009 --- sos fs: Maybe you spoiled me in the past :-) - 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
