[V4WS] UPDATE...WHERE problem

[Ruslan Zasukhin]

On 6/11/04 3:27 PM, "Richard Altenburg" <valentina at brainchild.nl> wrote:

> On 11-06-2004 07:56, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:
> 
>> Correct is
>> 
>>   WHERE fld is NULL
> 
> I hoped this would de the solution to my show stopper problem on Windows,
> where the update and indexing still does not work, but when I tried this
> syntax, I got errors. The proper way is WHERE fld = NULL I guess...

No no. 

    fld is NULL

We cannot use operator = with NULL value,.
This is rule of standard.

-- 
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
-------------------------------------------------------------