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