2008/11/7 Rob Sciuk <[EMAIL PROTECTED]>: > > 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?? > > Cheers, > Rob Sciuk >
Hi Rob, I haven't tried this, but sqlite3_column_type(sqlite3_stmt*, int iCol) should do what you want: http://www.sqlite.org/c3ref/column_blob.html Rgds, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
