Is there a way to get more fine-grained error information from SQLite
in the case of a SQL error, other than the error message? I'm
thinking of the particular case of a table already existing that you
try to CREATE TABLE on -- right now, you just get SQLITE_ERROR and the
actual error is in the error message. Any chance of extending
sqlite3ErrorMsg to also take a more detailed error code as well as the
string, that can be retreived in some way? Probably too late to add
new error codes, but maybe a sqlite3_sql_errcode() that returns a
number that's only valid if SQLITE_ERROR is returned?
I can do the patch for this if there's interest.
- Vlad