> > I don't see in the documentation a function to return whether or not the > database value returned by the sqlite3_step() function is NULL. Surely there > should be such a beast, no? > > Something like: > int sqlite3_column_isNull( stmt, i ) ; > or even: > int sqlite3_column_isDefined( stmt, i ) ; > > > This should work across all datatypes, and simply allow proper null handling > -- > not relying upon affinity dependant conversions ... hopefully, I've simply > overlooked something really obvious, but at this moment, is opaque to me ... > any pointers?? >
Ooops, it appears that sqlite3_column_type( smt, i ) returns SQLITE_NULL iff the data are missing. Is this correct?? Cheers, Rob Sciuk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users