Sorry, should have pointed out that the "missing" tables are: CollectionDevices and CollectionChannels
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Eric Teutsch Sent: November-30-13 14:04 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Bug in sqlite.exe? I've taken a picture of the odbc tool (showing the tables and the database name) and sqlite.exe with .database and .table showing. You can see it here: http://www.powersoft.ca/files/sqlite.png It's the same file... -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: November-30-13 13:13 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Bug in sqlite.exe? On 11/30/2013 11:55 AM, Eric Teutsch wrote: > .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. My educated guess is, you are not looking at the file you think you are looking at. Somehow, in the shell you are opening a different database file than the one you are opening in other tools, and that file does indeed have 8 tables and 1 trigger. -- 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users