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 [email protected] Mon May 25 18:10:56 +0000 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
