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). Ran 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> >
