The database has been closed and opened many times, by both the application, as well as different adhoc query interfaces (sqlite.exe, sqlite expert, qtado -- I've made sure that all access is terminated). The database has been deleted (no complaints like file is in use...) and regenerated with same effect. The only thing I haven't done in a while is reboot of computer, I'll try that overnight.
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: November-30-13 12:56 To: General Discussion of SQLite Database Subject: Re: [sqlite] Bug in sqlite.exe? On 30 Nov 2013, at 5:43pm, Eric Teutsch <er...@powersoft.ca> wrote: > That is an interesting concept and could explain another weirdness - > my sqliteodbc connection always tells me that the database is > readonly. Is there a way to find out if a database is in a > transaction and waiting for a commit or a rollback? The correct answer to this is to try closing the database or doing another BEGIN. Using the proper SQLite API you should get an error that they can't be done because you're in the middle of a transaction. However a lot of pretend APIs try to help you by tidying up loose ends for you and won't admit anything is wrong. Simon. _______________________________________________ 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
