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?
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Keith Medcalf Sent: November-30-13 12:11 To: General Discussion of SQLite Database Subject: Re: [sqlite] Bug in sqlite.exe? COMMIT ? >-----Original Message----- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Eric Teutsch >Sent: Saturday, 30 November, 2013 09:56 >To: 'General Discussion of SQLite Database' >Subject: Re: [sqlite] Bug in sqlite.exe? > >.Tables doesn't show the 2 new tables. A select statement on one of >those tables says "No such table". And "select * from sqlite_master" >shows the >8 >tables and 1 trigger. And ends there. But when using sqliteodbc, I >can run the select statement on a new table. > >-----Original Message----- >From: sqlite-users-boun...@sqlite.org >[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik >Sent: November-30-13 11:36 >To: sqlite-users@sqlite.org >Subject: Re: [sqlite] Bug in sqlite.exe? > >On 11/30/2013 10:01 AM, Eric Teutsch wrote: >> But when I look at the database with sqlite.exe (3.8.0.1), I see the >> 8 of tables and 1 trigger. I cannot query the remaining two tables. > >Define "cannot". Exactly what happens when you try? What do you mean by >"see" - see where and how? > >Can you show the results of this query: > >select * from sqlite_master > > >_______________________________________________ >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 _______________________________________________ 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