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

[jda]

>>>>
>>>
>>>Did not catch.
>>>
>>>If db is empty. The all right. No match
>>>
>>
>>Sorry, I shouldn't have written empty. My databases always have one 
>>record -- I meant that this record had no entries in any field. So 
>>title IS NULL, but I didn't get a hit.
>
>Jon, just to be clear. NULL is different than empty for a text 
>field. Are you sure the field is not simply empty?
>

Well, I *think* it is really NULL. I have this written in the code 
that updates text fields:

     if TextField(index).text = ""  then
       myCursor.TextField(fldName).deleteData //set text field to null

So, at least in V1.x, I thought this "nulled-out" the field.

Jon