[dba-issues] [Issue 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 User clu changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |fs --- Additional comments from [EMAIL PROTECTED] Tue Apr 3 15:45:01 + 2007 --- clu->fs: is it senseful to improve this error message? - 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 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 User laura36 changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from [EMAIL PROTECTED] Tue Dec 12 13:44:56 -0800 2006 --- well, I found the mistake recently. It was more or less my mistake rather then a bug. In the former versions of openoffice it was possible to use just the tablenames in a query - whithout the name of the database: like: select * FROM persons No you get the described error message. If you use "select * FROM `adressen`.`persons` it works. So better not to speak about a bug but a bad error message. - 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 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 --- Additional comments from [EMAIL PROTECTED] Sat Nov 4 18:19:37 -0800 2006 --- I'm having the same issue, using PostgreSQL with the SDBC connector. I've just noticed that what seems to trigger the error for me is when I name a query the same as a view I'm calling. I believe Base now doesn't like it if the query name matches a table or view in the database. WORKAROUND: Rename Base's query object to something different than the tables/view included in the query. This should prevent the error until this behavior is changed or a more informative message is provided for the user when creating/executing 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: [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 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 User laura36 changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |39704) sql-query to create | | the database, formulars a | |nd .odb file --- Additional comments from [EMAIL PROTECTED] Thu Oct 12 06:57:40 -0700 2006 --- Created an attachment (id=39704) sql-query to create the database, formulars and .odb 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: [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 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 --- Additional comments from [EMAIL PROTECTED] Thu Oct 12 06:56:12 -0700 2006 --- I'll attach a tgz-archive which contains: - the sql-command to create the database-structure (in mysql - I'm running 5.0.24) It only create the tables the database must be created before. You can just run it in phpmyadmin. - on formular (the complete one) (which is part of the frontend of the database) - the .odb file to make it work in openoffice the database must be registered as "adressen" I hope that's all to reproduce it (or not) I connected it via odbc, I didn't try it yet with jdbc. Again: Database-structure and formulars worked perfektly under oo 2.0.2 and 2.0.3 but not with 2.0.4_rc3 The structure may be a little bit complicated. To understand the formular: You can search with the formular "form_suche.odb" in three tables "personen" "organisationen" and "inorgapersonen" -> persons, organisations and people belong to organisations. Each resultset ist showed in an different area of the search formulars. The "details-buttons" are linked again to other formulars. (it's still de - 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 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 --- Additional comments from [EMAIL PROTECTED] Thu Oct 12 03:55:14 -0700 2006 --- What still stops me from reproducing is the missing table structure. If you could - open a new query in SQL view - press the "Run SQL Direct" button - enter and execute a SHOW CREATE TABLE for every table of your database - attach the results here this would be most helpful. This will dump the SQL commands which are necessary to duplicate your table structure. - 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 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 --- Additional comments from [EMAIL PROTECTED] Wed Oct 11 06:02:00 -0700 2006 --- "person" is a table. there aren't queries where the formulars are reference to. All queries are made in the formulars by itself. The formular i posted is an simple cut out of an more complex formular. but the error also occurs on the simple 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: [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 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 --- Additional comments from [EMAIL PROTECTED] Wed Oct 11 05:57:02 -0700 2006 --- I attached the database file. indeed it is just the file with the connection to the mysql-database. I started to transform it in HSQLDB but I haven't finished it. - 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 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 User laura36 changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |39686) database file where | | the error occurs --- Additional comments from [EMAIL PROTECTED] Wed Oct 11 05:54:16 -0700 2006 --- Created an attachment (id=39686) database file where the error occurs - 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 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 --- Additional comments from [EMAIL PROTECTED] Wed Oct 11 01:20:44 -0700 2006 --- Can you attach the database file (the .odb file which is registered as data source "adressen"). Is "personen" a table or a query in this database 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: [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 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 --- Additional comments from [EMAIL PROTECTED] Mon Oct 9 13:48:41 -0700 2006 --- sorry, i didn't mention, that my example database is connected via odbc (unixodbc 2.2.11) to mysql(5.0.24), debian testing. - 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 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 User laura36 changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |39656) a formular where th | |e error occurs --- Additional comments from [EMAIL PROTECTED] Mon Oct 9 13:46:40 -0700 2006 --- Created an attachment (id=39656) a formular where the error occurs - 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 70248] Analyzing SQL query in For mulars fails. Message: "The Statement contains a cyclic reference to one ore more subqueries " in OOo 2.0.4_rc3-1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70248 Issue #|70248 Summary|Analyzing SQL query in Formulars fails. Message: "The |Statement contains a cyclic reference to one ore more |subqueries" in OOo 2.0.4_rc3-1 Component|Database access Version|OOo 2.0.4 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|laura36 --- Additional comments from [EMAIL PROTECTED] Mon Oct 9 13:44:05 -0700 2006 --- On opening formulars (if they contain subqueries or not) in OOo 2.0.4._rc3-1 the error message occurs: "The Statement contains a cyclic reference to one ore more subqueries" and dont work anymore. The same formulars worked perfectly in 2.0.3. The problem seems to be related to the content type of the data source in the form properties. If it is set to SQL and the Option "Analyze SQL-Command" is set the error occur. If it is set to "No" it works. - 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]
