How to prevent sqlite_reset reporting an already known error

I am executing a prepared statement S with a couple of different bindings. The execution sequence is similar to this

while (moreBindings)
{
 bind_parameters_to_prepared_statement;
sqlite3_step();

if (error)
{
…
}
sqlite_reset();
if (error)
{
}

}

The issue is that sqlite_reset() reports the same error that already sqlite3_step() reported. How can I prevent that sqlite_reset() reports the same error. I also tried to clear the bindings before the reset statement but this did not help either.

PS: Actually, I am using not directly the SQLite statement but a wrapper around it that makes it a bit more complicated to filter out the multiple reported same error.

Regards,
Hardy

_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users