Re: [PyQt] Sqlite3 'database is locked' errors

2012-01-23 Thread Brian Zambrano
I ended up solving this but it's very odd. I do my own DB work with QSqlQuery, but commit any transaction I open. I have two QSqlTableModels which I use. In one of the QSqlTableModels I was using setQuery to select a subset of the columns I needed. That ended up being the issue. When I remove

[PyQt] Sqlite3 'database is locked' errors

2012-01-19 Thread Brian Zambrano
In my application I have a Sqlite db which at times needs an updated schema. To work around some issues on Windows, I need to do "drop table" for each table. However, I'm continuously getting: "database is locked Unable to fetch row" after each "DROP table table_name" statement. There are no o