Hi, I tried inserting two rows the same unique index. sqlite3_step() failed, as expected, but returned 1 (SQLITE_ERROR). Even sqlite3_errcode() returned 1 (SQLITE_ERROR). I would have expected error 19 (SQLITE_CONSTRAINT) to be returned.
I was also surprised that the next sqlite3_reset() returned 19 (SQLITE_CONSTRAINT) instead of 0. Only the second consecutive sqlite3_reset() returned 0. Should a non-zero result from sqlite3_reset() be considered an error? How can I get a more detailed NUMERIC error result (in this case error 19) from sqlite3_step()? Thanks, Ron
