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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:sqlite-users- >[email protected]] 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: [email protected] >[mailto:[email protected]] On Behalf Of Igor Tandetnik >Sent: November-30-13 11:36 >To: [email protected] >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 >[email protected] >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >_______________________________________________ >sqlite-users mailing list >[email protected] >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
