To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105872
------- Additional comments from arp...@openoffice.org Wed Oct 21 07:09:21 +0000 2009 ------- In addition, I can report that on Debian Lenny (HSQL 1.8 latest public stable version running on the same machine with OpenOffice 2.4.1, the latter originating from a Debian repository), I get a similar, perhaps related error: 1) I create the test table 2) I connect OpenOffice Base to my database 3) I create a test query as "SELECT * FROM PRODUCT" 4) I run the query, see some result data 5) I try to apply a standard filter 6) The filter dialog opens, shows column names 7) I try filtering by "ID = 2" or "CODE = 003" The following error occurs: > SQL Status: 37000 > Error code: -11 > Unexpected token: in statement [SELECT * FROM "PRODUCT" WHERE ( "" = 2 )] Observing HSQL trace mesages confirms that too - basically, something in OpenOffice failed adding a field name to the filtering statement, possibly since it earlier failed querying field names from HSQL, yet ability to display them in the combo box of the standard filter dialog indicates this failure is not global. --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org