> But this is a bug, don't you?

No it's not. I explained that to you. There's no such thing as
MYCOLUMN = NULL --- this does not work. If you replace NULL
by a parameter and set it to NULL, it will still not work.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> At 15.36 29/07/2002 +0200, you wrote:
> >Claudio,
> >
> > > I've an xml with value's column and I don't know if a value is null.
> > > I make the where condition dinamically and i set the ? with the value
> > > in the xml.
> > > I can't do "DETRANSFER is null" or any other columns
> >
> >since you are building the where condition dynamically, it should'nt be
> >that much of a problem to cater for the special case of null values;
> >after all you *already* are treating null differently, since you must
> >knwo when to call setNull.
> >I don't see any simpler way out, sorry.
> >Ciao
> >--
> > ____
> >_/\/ando