Subject | Re: [Firebird-Java] Re: Problem with Not null colum indicator |
---|---|
Author | Carlos Guzmán Álvarez |
Post date | 2002-10-24T16:27:46Z |
Hello:
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.
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
> Why not? row[i] is null only when sqlind was -1. If sqlind was 0,As I known sqlind is for know if a column allow null values and not for
> 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?
>
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