Thanks Igor! I used an equivalent function in Qt called QSqlQuery::clear() that did the job.
Igor Tandetnik wrote: > Pankaj Gupta <pankaj.gu...@stjude.org> > 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 remove the 'select' statement. >> > > You must reset or finalize all open statements before comitting the > transaction. > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
