[sqlite] COMMIT or ROLLBACK failure

[Igor Korot]

Hi, ALL,

Consider following piece of code:

int res = sqlite3_exec(..., "BEGIN"... );
if( res != SQLITE_OK )
{
     printf( "Error occured on begin transaction. Please try again." );
     return;
}

// some operations on the database

// if operations are successful
     sqlite3_exec( ..., "COMMIT", .... );
// else
     sqlite3_exec( ..., "ROLLBACK", ... );

Now, AFAIU, I need to check if the COMMIT is successful.
But what should I do if it fails? Do I just report the failure to the user?
Do I need to call ROLLBACK? And what if it will also fail?
And in "else" branch - do I check for "ROLLBACK" result? And if it fails
what do I do?

Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users