To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=57513 Issue #:|57513 Summary:|OO Base frontend does not recognize UNION SELECT |statements Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|fqs7432
------- Additional comments from [EMAIL PROTECTED] Tue Nov 8 05:46:52 -0800 2005 ------- The function SELECT CASE WHEN works in queries and views, but if a query contains such a statement, the design view of the query is no longer available and the report generator will refuse to show the fields of that query. I tried to fool the report generator, by generating a report before the query contained the union select part (the second select statement, which follows the word UNION, included), and afterwards modifying the query, but the report won't generate any report, merely the layout template, if used once the query was made to include the UNION SELECT part. --------------------------------------------------------------------- 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]