Sqlite commit fails - "cannot commit - no transaction is active Unable to commit transaction"
General and Desktop
2
Posts
2
Posters
3.0k
Views
2
Watching
-
wrote on 9 Apr 2015, 07:44 last edited by
I am doing sql transaction in qt.
bool X::save() { mDatabase.transaction(); if (!saveHeader()) { mDatabase.rollback(); return false; } if (!saveBody()) { mDatabase.rollback(); return false; } mDatabase.commit(); return true; }
My commit returns fails an returns "cannot commit - no transaction is active Unable to commit transaction"
I have SELECT and DELETE query in the functions. But I do query.clear(); after execution.
Still I get this error. Someone knows why...
-
I am doing sql transaction in qt.
bool X::save() { mDatabase.transaction(); if (!saveHeader()) { mDatabase.rollback(); return false; } if (!saveBody()) { mDatabase.rollback(); return false; } mDatabase.commit(); return true; }
My commit returns fails an returns "cannot commit - no transaction is active Unable to commit transaction"
I have SELECT and DELETE query in the functions. But I do query.clear(); after execution.
Still I get this error. Someone knows why...
1/2