To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63076 Issue #:|63076 Summary:|Query with true/false produces SQL-error Component:|Database access Version:|OOo 2.0.2 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P1 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|theblanz
------- Additional comments from [EMAIL PROTECTED] Sun Mar 12 04:02:42 -0800 2006 ------- Hi, I was just playing around with a query. So it is not possible to do a query with a "KRITERIUM" (sorry what is it in English?!) TRUE/FALSE. If you have a yes/no-Field and want to do a query IS TRUE or IS FALSE, it always says: "SQL-error - expects NULL." I played around: "IS 1" or "IS '1'" or "= '1'" or "= 1" or "1" or "0" etc. Nothing works. I used HSQL. With MySQL it works with a bit-field and "= 0" or "= 1". I think this is a real major bug! Perhaps it has something to do with bug #18201 or vice versa. See this forum (in German): http://www.oooforum.de/viewtopic.php?t=4602 Yours Christoph --------------------------------------------------------------------- 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]