To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89335
User atjensen changed the following: What |Old value |New value ================================================================================ Status|UNCONFIRMED |RESOLVED -------------------------------------------------------------------------------- Resolution| |WORKSFORME -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Thu May 15 03:15:28 +0000 2008 ------- I am setting this issue to 'worksforme' for the following reason. First - the action described is the query designer functioning as designed. Second - the design does follow proper SQL standards. In the query designer, in the criteria text box you can enter the strings "IS NULL" or "IS EMPTY" to return all records where the field's value is NULL. You can also enter just the strings "EMPTY" or "NULL" in which case the query parser generates correct SQL of "Column" = NULL. The SQL 92 standard states 'if one of the operands is NULL, the result of the comparison is "UNKNOWN".'. In other words the result set would be zero records, which is exactly what Base returns. Not often what you actually wanted, but it is valid SQL none the less. --------------------------------------------------------------------- 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]