Andreas Saeger wrote:
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)" <> '' ) )
Hello Andreas,
hmm - the use of an empty string does not work for me. I get back zero
records when I know there should be dozens.
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?
Actually I was going to ask about that - the fact that both IS NULL and
IS NOT NULL are being handled in the same issue, and see if folks wanted
that broken back into two separate issues.
Drew
--
OpenOffice.org User Community Forum: http://user.services.openoffice.org
United States PostgreSQL Association: http://www.postgresql.us/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
