Subject | Re: Does FB support SQL isnull(...) ? |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-06-01T06:49:50Z |
> ... I can't make it work. If it is supported, can someone indicate theSee javadocs for java.sql.ResultSet.wasNull() method. Main idea is
> correct syntax? (I'm looking thru help....)
that first you have to read column value. If the getXXX method returns
non-primitive type (i.e. subclass of java.lang.Object), then you get
null value. But if method returns primitive type (int, long, double,
etc.), you get a default value from the specification (usually 0 or
0.0) and then you have to check value of ResultSet.wasNull() method.
Roman