>SQLITE_ERROR result, and you can examine the error message text What error message text? So far as I can see, sqlite3_prepare and sqlite3_prepare_v2 simply emit a return code and NO error message. If I get SQLITE_ERROR i.e. 1, how does that tell me whether it is the table that does not exist, or that it is the column that does not exist, or that neither exist?