[V4WS] UPDATE...WHERE problem

[Ruslan Zasukhin]

On 6/11/04 8:36 AM, "Solon Morse" <smorse at rtpi.org> wrote:

> I reported this some time ago, and I'm wondering if there might be a fix (or
> maybe my syntax is wrong with V4WS?):
> 
> V4WS 1.10. 
> 
> f is a nullable field.
> 
> valSqlExecute(dB,"UPDATE tbl SET f = null WHERE f = 'whatever'");
> 
> sets f to string "null" for varchar
> sets f to 0 for numeric
> 
> It seems to be treating null as the string "null".

Syntax is wrong, Solon.


Correct is

    WHERE fld is NULL
             ^^^   


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