Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | OO Base frontend does not recognize UNION SELECT statements | ||||||
---|---|---|---|---|---|---|---|
Product: | Base | Reporter: | fqs7432 <afolger> | ||||
Component: | code | Assignee: | AOO issues mailing list <issues> | ||||
Status: | UNCONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues | ||||
Version: | OOo 2.0 | ||||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | Linux, all | ||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
fqs7432
2005-11-08 13:46:52 UTC
Created attachment 31261 [details]
ODB file with two small tables, one query and one report to demonstrate the problem.
Sorry, the text in the first paragraph contains an error. Instead of "The function SELECT CASE WHEN" it should read "The UNION SELECT statement" several 'handmade' sql strings cannot be 'translated' in the query design ui - this is one of them - to improve the query design in this direction make sense send further to: 'requirements' |