Hi Claudio,

> At what to be used for the PreparedStatement if I have to build

dinamically

> the statement given that the setNull doesn't select the data?
>
> The setNull isn't useful and if i have the possibility to have null value
> the PreparedStatement isn't useful too.

Well, don't use a PreparedStatement, or only use parameters for NOT NULL
values.

There's a little bit more programming to do for you ... but this is how
SQL works - not just FB or IB or the JDBC driver.

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."