Your question has been asked earlier this year, and no solution was posted. I'm interested to find out whether things have improved. To summarise the earlier post:
1) sqlite3_column_int() returns the value stored in that column, or 0 if an error occurred. <https://sqlite.org/c3ref/column_blob.html> (last para) 2) If the value returned is 0, there's no way to tell whether it's because of an error or 0 really is the value returned in that column. 3) Presumably you're meant to call sqlite3_errcode() to find out which it is. 4) However, if the most recent API call was successful, then the return value from sqlite3_errcode() is undefined. It could be an error code. It could be 0. <https://sqlite.org/c3ref/errcode.html> (first para) 5) Similar problems occur with some other sqlite3_column_*() functions. 6) As a result, the programmer cannot perform error-checking for these functions. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
