> > Thanks to both of you for your answers.
> >
> > @Roman: Is there a way to tell if a field is NULL without reading it?
>
> Depends on what level you want this info.
>
> - In SQL you can add IS NULL clause to the WHERE conditions.
>
> - On the API level you can check the sqlind field of the XSQLDA/XSQLVAR
> structure
>
> - On JDBC API level you use ResultSet.wasNull(...) call.

Unfortunately, you can only call wasNull() after requesting the field itself.

Mark
--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01