V4RB ... why does this SQL fail?

[Ruslan Zasukhin]

on 3/11/03 8:54 PM, Pedro fp at lists at pedro.net.au wrote:

> Should
> 
> WHERE WHERE fieldName = ''
> 
> work? [it does with REALdb]

NO !!!

Above query will search EMPTY strings.

But NULL value is something different to EMPTY string, you see?


> Using LIKE was what I tried when = failed. However both work for the
> VVarChar field.

Most probably for this VarChar field you have NOT specified Nullable flag.

This is why IT SEEMS to you that it works.
If field is NOT Nullable, then NULLs are stored as empty strings of course.
 

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------