Ran escreveu:
I think that sqlite3_column_type suppose to tell you if it is NULL.
http://www.sqlite.org/capi3ref.html#sqlite3_column_type
It returns SQLITE_NULL in that case.
However I don't see how you can avoid calling two functions in a scenario
you suspect a NULL (so if sqlite3_column_int returns a zero, you should call
sqlite3_column_type to check if it is NULL).
Thanks. This is what i was looking for.
Luiz
On 2/28/06, Luiz Americo Pereira Camara <[EMAIL PROTECTED]> wrote:
The sqlite documentation states that when the stored value of an Integer
field is NULL and is used sqlite3_column_int to retrieve the data, the
returned value is 0.
Currently to know if the value is zero or NULL i check the value of
sqlite3_column_text (that returns NULL in that case). The drawback of
this solution is that i retrieve two times the same record. Is there a
more straight forward way of doing this?
Thanks In Advance,
Luiz
<http://www.sqlite.org/capi3ref.html#sqlite3_column_int>
