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

[Ruslan Zasukhin]

On 11/11/04 9:47 PM, "jda" <jda at his.com> wrote:

>> Actually correct syntax is
>>     SELECT * from thereferences WHERE title IS NULL
>> 
>> 
>> Ivan, please add to our VSQL_Test_User_Errors group this query
>>     SELECT * from thereferences WHERE title = NULL
>> 
>> Make sure it not crashes but return error.
> 
> Thanks for the correction.
> 
> One more little problem, then.
> 
> I tried
> 
> SELECT hit from thereferences WHERE title IS NULL
> 
> on an empty db and got no match...

Did not catch.

If db is empty. The all right. No match


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------