On 1 Oct 2017, at 6:56pm, Bart Smissaert <bart.smissa...@gmail.com> wrote:
> I can see that if there is no error then then return value of
> sqlite3_errcode() can be SQLITE_ROW (100) or SQLITE_DONE (101). So, to
> check if there is an error (other than looking at all the
> return values) do I need to check that sqlite3_errcode() returns something
> other than 0, 100 or 101 or are there other values that could be returned
> that don't indicate an error?
There’s no good way to do this. You have to check the code returned by each
function call as it is returned.
You could check sqlite3_errcode() and find it give you an error code. But you
don’t know if that error was caused by the most recent function call or one
five calls ago. And sqlite3_errcode() might theoretically return 100, but that
doesn’t mean there wasn’t an error before the last successful call to
If you check the codes returned by each function call instead, then your list
is correct: 0, 100 and 101 indicate success (of a kind). Any other value means
a failure. However, in theory all values from 1 to 99 would be errors, and
using this range might help to future-proof your code.
sqlite-users mailing list