[BUG, Ivan] Searching for an empty/non-empty field

jda jda at his.com
Thu Nov 11 15:13:41 CST 2004


>.
>
>Did not catch.
>
>If db is empty. The all right. No match
>

One last piece of info -- if I use

title IS NOT NULL

it DOES match all records where the title is empty AND when the title 
field has text (title is VText, indexedByWords, if that matters).

So, IS NOT NULL always matches, regardless of whether the field is 
empty or not.

Jon


More information about the Valentina-beta mailing list