[api-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 Tue May 26 06:57:06 + 2009 --- For a workaround try oStatement.EscapeProcessing = False Before executing the command and see if that fixes 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...@api.openoffice.org For additional commands, e-mail: issues-h...@api.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[api-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...@api.openoffice.org For additional commands, e-mail: issues-h...@api.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[api-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 Issue #|102234 Summary|Database query does not work correct in API code Component|api Version|OOo 3.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|code Assigned to|jsc Reported by|sarotti --- Additional comments from saro...@openoffice.org Mon May 25 18:10:56 + 2009 --- Hi, I created several database query's in my macro code which are not running with OO 3.1. These querys all have relations between more than two tables and are defined like this: „... sSQL=SELECT `DOKUMENT`.`Kapitel`, `DOKUMENT`.`Typ`, `DOKUMENT`.`Titel`, `DOKUMENT`.`Link`, `DOKUMENT`.`Blatt`, `DOKUMENT`.`Nr`, `DOKUMENT`.`erlDatum`, `DOKUMENT`.`Revision`, `DOKUMENT`.`DotName` FROM `VertNeu` `VertNeu`, `DOKUMENT` `DOKUMENT`, `Handbuch` `Handbuch` WHERE ( `VertNeu`.`ID_Dokument` = `DOKUMENT`.`ID`) AND (`VertNeu`.`ID_Handbuch` = `Handbuch`.`ID_Handbuch` ) AND ( ( `Handbuch`.`Nummer` = '05' ) ) AND ( ( `Handbuch`.`Abteilung` = 'QW-L' ) ) ORDER BY `DOKUMENT`.`Kapitel`, `DOKUMENT`.`Nr` ASC oErgSet=oStatement.executeQuery(sSQL) ….“ This code is running perfect with OO 2.4 - with 3.1 there is a frozen / hanging system. Also the change to an LEFT OUTER JOIN query has the same effect, but is only working correctly with two related tables. Using the SQL code in the database directly the query only is running when the SQL code is used as a direct command (like before in the macro code in OO 2.4.1). I found no way to define my macro code to work as a direct query command (e.g. with the API command naturalSQL) Because I need this query's to operate with my several databases in my company, I need top urgent a solution for this issue. Thank you for your assistance. P.S. It´s an MS-Access 97 Database. But the test with an HSQL database shows the same behavior - 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...@api.openoffice.org For additional commands, e-mail: issues-h...@api.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[api-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 jsc changed the following: What|Old value |New value Assigned to|jsc |fs Priority|P1|P3 --- Additional comments from j...@openoffice.org Tue May 26 05:51:34 + 2009 --- first of all it's no P1 issue, please let the priority on the default value if you are not sure. I changed the prio to P3 and the database engineers will take are of it jsc - fs: seems to be one for you. - 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...@api.openoffice.org For additional commands, e-mail: issues-h...@api.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org