To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49974
User atjensen changed the following: What |Old value |New value ================================================================================ Status|RESOLVED |UNCONFIRMED -------------------------------------------------------------------------------- Resolution|WORKSFORME | -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Wed May 21 06:37:13 +0000 2008 ------- Confimed w/ XP and OO.o 2.4 and 3.0 Beta against a Thunderbird 2.0.14 addressbook the use of IS NULL, IS EMPTY, <> NULL, <> EMPTY all return the same results, which is records where the tested firls IS NOT NULL. While IS NOT NULL generates an error of "SQL to complex". So it is not possible to query for records where a certain field is NULL. --------------------------------------------------------------------- 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]