[dba-issues] [Issue 57513] New - OO Base frontend does not recognize UNION SELECT statements

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[dba-issues] [Issue 57513] New - OO Base frontend does not recognize UNION SELECT statements

fqs7432
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 [hidden email] 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: [hidden email]
For additional commands, e-mail: [hidden email]