Get SQLite3 error message from error code

Question

There is a (potential) problem with using sqlite3_errmsg():

it might be the case that a second error occurs on a separate thread in between the time of the first error and the call to these interfaces

So if I already have a error code returned by some function, can I get the corresponding error message in some other way?

Haju Schulz · Accepted Answer · 2013-07-23 09:13:55Z

3

There is a public API wrapper for sqliteErrStr() that you can use

SQLITE_API const char *sqlite3_errstr(int rc);

answered Jul 23, 2013 at 9:13

Haju Schulz

463 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nick Dandoulakis · Accepted Answer · 2012-04-19 14:18:44Z

1

The function that does the job is

SQLITE_PRIVATE const char *sqlite3ErrStr(int);

but is declared as PRIVATE aka static.

In the docs they propose to lock the database connection and then read both the error code and the error message.

An alternative easy solution is to make the function public, if you have access to the source code.

answered Apr 19, 2012 at 14:18

Nick Dandoulakis

43.3k17 gold badges106 silver badges139 bronze badges

Thank you. I've seen the suggestion in docs but hoped for a simpler way.