Subject RE: [IBO] NULL in TIB_Query.Params
Author Helen Borrie
At 10:41 AM 09-01-01 +0100, you wrote:
>True, it could be useful - but I think Jason would have to change the SQL
>to make this work (since = is not the same as IS), hence the need to
>reprepare. Jason, does TIBOQuery emulate TQuery in this case (or does
>TIBQuery behave like TIBOQuery and differ from TQuery)?
>
>Helen, any plans for Firebird to support 'SELECT * FROM TEST WHERE A = NULL'?

No, that will never happen because there is no equivalence for Null. "Null
is a state not a value".

Helen

All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________