To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105872 Issue #|105872 Summary|Form filters break with a HSQL 1.9 backend Component|Database access Version|OOo 3.1.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|arp123
------- Additional comments from [email protected] Tue Oct 13 15:11:01 +0000 2009 ------- Form filters in Base behave differently with HSQL 1.8 and 1.9 database backends. Their behaviour with 1.9 is errant. With 1.8 (either the version integrated with OpenOffice, or any later version), selecting the form filter tool from the toolbar empties all usable fields. After this, the user can write into them and apply the filter. With 1.9, the fields are not emptied, cannot be written to, and likewise, the filter cannot be applied. This occurs even with a minimum test table (id INTEGER PRIMARY KEY, code VARCHAR, name VARCHAR). If I create such a test table, enter some data into it, and create a form to represent it under the embedded HSQL 1.8, or using a remote HSQL 1.8 server, form filters work. As soon as I try with a remote HSQL 1.9 server (repackaging OpenOffice to have it embedded is a too big job for me), this specific functionality fails. Other functionality like browsing records and establishing filters by writing SQL into the "filter" field of a form, continue to work 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]
