Drew Jensen wrote: > Hi, > > The issue is regarding the use of IS NOT NULL as a criteria for a Base > file connected to a Thunderbird Addressbook.. > > I could find nothing in the way of a specification to tell me if this is > supposed to be supported or not? > > Thanks much > > Drew >
Hi Drew, Your issue has been marked as duplicate of 49974. That one refers to comparision with Null and empty strings in Outlook Express address books: > 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.). > [...] > Company = '' ' OK, no records > Company <> '' ' ??, all business contacts > The latter comparisons (='', <>'') work for me with a Thunderbird address book where I filter out all persons without email address: > SELECT "Display Name", "E-mail", "E-mail (2)", "Mail Format" FROM "Personal > Address book" WHERE ( ( "E-mail" <> '' ) OR ( "E-mail (2)" <> '' ) ) Nonetheless, I get a wrong error message when I open the query for edit in any mode: > "The query does not create a result set, and thus can not be part of another > query." So the Mozilla related issues 87236 and 87237 may differ from the 49974 and thus not beeing duplicates. Possibly there is one issue with [NOT]Null in several address books and another one regarding empty strings in OE? Hope this helps, Andreas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
