At 11:53 AM 09-01-01 +0100, you wrote:

> > >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".
>
>I would suggest to add NULL support in TIB_Query.Params instead, if it
>doesn't exist already. I imagine that after TParams[xx].Clear; the
>underlying statement would be interpreted as '<param> IS NULL' without
>having to change the SQL property in code.
>Not being familiar with the details of implementation, I only hope that it's
>a reasonable request. It's definitely nothing urgent, though.

It's unlikely, since it isn't valid SQL. But I'm sure Jason did something
in the SQL parser routines not long ago, after a change to something ended
up with an SQL statement like

select Field1, field2 from aTable where Field1 = is null.

As a matter of interest, what's the trace monitor showing you?

TSh.

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