To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49974 Issue #:|49974 Summary:|DB Access to Outlook Express AddressBook, NULL value |handling Component:|Database access Version:|680m104 Platform:|PC URL:| OS/Version:|Windows 2000 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|msc Reported by:|fuege
------- Additional comments from [EMAIL PROTECTED] Fri May 27 15:30:06 -0700 2005 ------- My Outlook Express AddressBook entries contain mostly contacts without a "Company", but some include a value there. So I composed a query to get either the 'personal' or the 'business' entries. SELECT [some fields] FROM ""OE Contacts"" WHERE Company IS [NOT] NULL The results are somewhat strange, especially IS NULL doesn't work (correctly), because the result set is the total opposite of what is expected. Here's a list varying the WHERE-clause: Company IS NOT NULL ' Parse ERROR: Statement too complex! Company <> NULL ' All business contacts, although invalid SQL! Company IS NULL ' All business contacts, too!, totally surprising!!! Company = NULL ' No records, but expected an SQL error (s. a.). The following depend on how the empty string in the underlying data source is handled, but they are not consistent anyway (strict SQL says that if either value in a comparison is NULL, the expression evaluates to UNKNOWN and therefore, no records should be in the result set): Company = '' ' OK, no records Company <> '' ' ??, all business contacts Company LIKE '%' ' OK, all business contacts --------------------------------------------------------------------- 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]