To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=57435 Issue #:|57435 Summary:|Unable to query on boolian fields Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|geoff_stansfield
------- Additional comments from [EMAIL PROTECTED] Sun Nov 6 09:08:56 -0800 2005 ------- I have downloaded OOo_2.0.0_Win32Intel_install.exe & installed on a Win 2000 Pro machine. I have checked the MD5sum and that is fine. Use "Wizard to create Query", select the required table and those fields with File Type set to Yes/No [BOOLEAN] are not on the list of Available Fields. Use "Create Query in Design View", select the required table and the fields with File Type set to Yes/No [BOOLEAN] are available for selection - but finding a criterion that works is not easy. These examples work : SELECT "id", "fred", "george", "flag" FROM "Table1" "Table1" WHERE (( "flag" = False )) SELECT "id", "fred", "george", "flag" FROM "Table1" "Table1" WHERE (( "flag" = True )) but I can only enter/modify the WHERE clause in SQL view mode. That done, I can toggle design view on/off - and see FALSE (or TRUE) in the criterion field, but if I edit the criterion I get "Warning. Syntax error in SQL statement" and the query will not parse/run/save. --------------------------------------------------------------------- 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]