Subject Re: [Firebird-Java] Re: Problem with Not null colum indicator
Author Carlos Guzmán Álvarez
Hello:

> Why not? row[i] is null only when sqlind was -1. If sqlind was 0,
> then row[i] is not null. Code seems to be a little bit strange, but I
> do not see problem there. Can you explain in details what you mean?
>
As I known sqlind is for know if a column allow null values and not for
know if a column value is null.

With this :

(row[i] == null ? -1 : 0)

if row[i] is not null sqlind will indicate that column don´t allow null
values and this is no true the column can accept null values.


>> How did you solve it in your .Net provider?

I solved it adding isc_info_sql_null_ind to sql_prepare_info in
isc_dsql_prepare ( and in isc_dsql_describe and in
isc_dsql_describe_bind ), and modifiying ParseTruncSqlInfo for get
isc_info_sql_null_ind value.

This allows to get null indicator without make a fetch.


Best regards
Carlos Guzmán Álvarez
Vigo-Spain