[dba-issues] [Issue 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from m...@openoffice.org Fri Jul 3 10:07:29 + 2009 --- verified in CWS dba32d find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba32d - 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 User fs changed the following: What|Old value |New value Assigned to|fs|msc --- Additional comments from f...@openoffice.org Wed Jul 1 09:24:45 + 2009 --- fs-msc: please verify in CWS dba32d - 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 User fs changed the following: What|Old value |New value CC|'atjensen,fs' |'atjensen' Assigned to|dbaneedsconfirm |fs Ever confirmed| |1 Status|UNCONFIRMED |NEW Priority|P3|P2 Target milestone|--- |OOo 3.2 --- Additional comments from f...@openoffice.org Tue Jun 2 08:50:47 + 2009 --- confirming, grabbing, targeting - 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 User fs changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from f...@openoffice.org Tue Jun 2 08:55:01 + 2009 --- regression of issue 51143, it seems :-\ The problem here is that the original WHERE clause is (temporarily) stripped from the statement, resulting in an SQL statement selecting from all 3 tables. The resulting result set would have over 8 million rows, and retrieving those takes a while for even the fastest DB engine ... - 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 User fs changed the following: What|Old value |New value Status|STARTED |RESOLVED Resolution| |FIXED --- Additional comments from f...@openoffice.org Tue Jun 2 08:57:08 + 2009 --- fixed in CWS dba32d find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba32d - 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 --- Additional comments from atjen...@openoffice.org Fri May 29 15:41:24 + 2009 --- @srotti - sorry for the delay. This morning I had a chance to look at this a little. Using OO.o 3.1 and the query as entered...yup - it runs and runs but never (at least not in 4 minutes) finishes. Oddly for me it matters not whether it is SQL direct or not. Also - at the moment I don't seem to have 2.4 installed under XP but I do have 2.3.1 and under this OO.o release it has exactly the same problems as under 3.1 So - I'll put a copy of 2.4.1 and give it a try and see what I see - 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 --- Additional comments from saro...@openoffice.org Fri May 29 16:58:26 + 2009 --- @atjensen: To be honest - I am not sure about version 2.4.1, because I tested it originally with 2.0.0 (in my company) and it was absolut O.K. The macros with the SQL query were running without any 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 --- Additional comments from saro...@openoffice.org Thu May 28 15:22:52 + 2009 --- ajtensen- using the Base MS Access connection under Windows to work with the .mdb file, not an external ODBC connection for instance? Correct, it´s the original MS Access OO driver... Sorry, but I have no example in a HSQL database, but I tried it and it was the same...not in the macro code - I have not tested this - but in the database query the frozen system was the same... - 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 User atjensen changed the following: What|Old value |New value CC|'fs' |'atjensen,fs' --- Additional comments from atjen...@openoffice.org Wed May 27 20:23:13 + 2009 --- @sarotti - Just hoped I could help you keeo working whle the defect process is worked. Just to be sure, you are using the Base MS Access connection under Windows to work with the .mdb file, not an external ODBC connection for instance? (although I did see that you say HSQLdb will do it also..but) I'll check it under XP later tonight using 2.4 and 3.1 - 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 User fs changed the following: What|Old value |New value CC|''|'fs' Assigned to|fs|dbaneedsconfirm Component|api |Database access QA contact|iss...@api|iss...@dba Subcomponent|code |none --- Additional comments from f...@openoffice.org Tue May 26 06:59:43 + 2009 --- fs-sarotti: Can you please attach a sample database, either MS Access or HSQLDB, so this issue can be cleanly reproduced? - 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 --- Additional comments from saro...@openoffice.org Tue May 26 19:45:45 + 2009 --- Created an attachment (id=62548) My sample Access 97 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 --- Additional comments from saro...@openoffice.org Tue May 26 19:54:07 + 2009 --- fs-Thank you for your fast feedback...attached you can find my Access 97 database with the problems in the query. atjensen-yes, it works in the macro code (oStatement.EscapeProcessing = False) but the same happens when creating a query in the database itself in the design mode. It´s a little bit strange for OO only hanging or freezing without a message...so my interpretation is, that there is a code failure in OO ... - 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