[sqlite] Cannot commit transaction - SQL statements in progress

I am using JDBC with SQLite and am running into a problem where I get the exception: Cannot commit transaction - SQL statements in progress I searched the net and posted in another forum but I can't seem to find a solution. Once I run the method below called AddMealPlan I cannot execute anymore

Re: [sqlite] cannot commit transaction - SQL statements in progress

Thanks Igor! I used an equivalent function in Qt called QSqlQuery::clear() that did the job. Igor Tandetnik wrote: > Pankaj Gupta > wrote: > >> I'm using SQLite 3.6.3 with C++ and Qt. >> >> My problem is that when a use a select statement in a transaction >> containing insert statements, I

Re: [sqlite] cannot commit transaction - SQL statements in progress

Pankaj Gupta wrote: > I'm using SQLite 3.6.3 with C++ and Qt. > > My problem is that when a use a select statement in a transaction > containing insert statements, I get an error: "cannot commit > transaction - SQL statements in progress - Unable to fetch row". The > transaction seems to work if I

[sqlite] cannot commit transaction - SQL statements in progress

Hi! I'm using SQLite 3.6.3 with C++ and Qt. My problem is that when a use a select statement in a transaction containing insert statements, I get an error: "cannot commit transaction - SQL statements in progress - Unable to fetch row". The transaction seems to work if I remove the 'select' sta

Re: [sqlite] cannot commit transaction - SQL statements in progress

Markus Kolb wrote: > Hello, > > I open one connection to a sqlitedb and do a few successful autocommited > sqlite3_exec() calls. > Then I want to use the db handle to call another sqlite3_exec() with SQL > code for a transaction. > Before I close the connection I call again sqlite3_exec() with S

[sqlite] cannot commit transaction - SQL statements in progress

Hello, I open one connection to a sqlitedb and do a few successful autocommited sqlite3_exec() calls. Then I want to use the db handle to call another sqlite3_exec() with SQL code for a transaction. Before I close the connection I call again sqlite3_exec() with SQL COMMIT to end the transaction.