The driver doesn't communicate with SQL but with its machine language.

However MYCOLUMN=NULL don't work in interbase becouse it's a syntax error.
JDBC Driver' interbase should communicate traslating the setNull in
MYCOLUMN in null

At 10.08 30/07/2002 +0200, you wrote:

> > 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
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Claudio D'Angelo
Software Consultant
ObjectWay S.p.A.
Via G.A. Boltraffio 7
20159 Milano (MI)
http://www.objectway.it



[Non-text portions of this message have been removed]