[V4WS] valSQLSelectRecords and methods

[Solon Morse]

On Fri, 09 Jul 2004 18:41:51 +0300, Ruslan Zasukhin wrote:
 
> No idea. Only on that table/db
> Or always?


The flag "accept nulls" for the method field was set -- when I turned it off valSQLSelectRecords returned the correct value. I created another database with same method: if "accept nulls" is on, <null> is returned, if "accept nulls" is off, correct value returned.

I'll make sure "accept nulls" is off for methods. The method is CONCAT((field1),' ',(field2)), so what happens if both fields are <null> but the method field won't accept nulls? Anything?

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