To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98163 Issue #|98163 Summary|Hard coded SQL in reports Component|Database access Version|DEV300m14 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|villeroy
------- Additional comments from [email protected] Fri Jan 16 23:38:39 +0000 2009 ------- Open the "Bibliography" database and add a query SELECT "Identifier" FROM "biblio" WHERE "Identifier" = 'OOO00' Create a most simple report based on that query (3 clicks in the report wizard). Close the report, change the query, for instance: SELECT "Identifier" FROM "biblio" WHERE "Identifier" <> 'OOO00' Reload the report. It shows the same single record although the query has changed. Work-around: Open the report in edit mode. Get the form navigator. It shows 6 hidden controls (named values as configuration). One of them is "Command". Get the property window for "Command". It's value is the SQL string of our query at creation time. Delete that SELECT query, save the report, load it, change query, reload report,... works as expected. --------------------------------------------------------------------- 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]
