[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