To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=57345 Issue #:|57345 Summary:|Problems with queries, views and reports in OO Base |2.0 Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|fqs7432
------- Additional comments from [EMAIL PROTECTED] Fri Nov 4 01:20:29 -0800 2005 ------- I'd like to report the following bugs: *A: after closing a database containing a view and reopening it, the tables are no longer accessible (that is one way to implement temporary views ;-)), queries no longer work, etc. Solution: unzip the odb file, modify the database/scripts file, and rezip everything (done it twice on different machines, FC4 i386 and FC4 x86_64). The table view will, however, of course, be gone. *B: Queries cannot take a query as input, only tables and table views. *C: 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. *D: Queries have trouble dealing with boolean fields in design view; these are not seen in the wizard and must be added manually in design view. Even then, design view won't accept comparing a boolean value to 0 unless it is entered in SQL view and then the design view button is clicked. *E: while SELECT ... UNION SELECT works on OOo on Windows, it doesn't work on Linux (see http://www.oooforum.org/forum/viewtopic.phtml?t=25209&highlight=&sid=f12a9e747da1ec0edb3711dd8a230339 ) Points A amd C are critical for me --------------------------------------------------------------------- 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]