[V4WS] UPDATE...WHERE problem

Solon Morse smorse at rtpi.org
Fri Jun 11 01:36:06 CDT 2004


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

Thanks,

Solon
-- 
Solon Morse
Assistant Director of Education
Roger Tory Peterson Institute
311 Curtis Street
Jamestown, NY 14701
Jamestown: (716) 665-2473 ext 243
Buffalo: (716) 886-1920
smorse at rtpi.org


More information about the Valentina mailing list