On 30 Nov 2013, at 3:01pm, Eric Teutsch <er...@powersoft.ca> wrote: > Hi, I've got a database (3.7.16.1) which has a bunch of tables and 2 > triggers. The order of creation is 8 tables, 2 triggers, 2 tables. When > looking at the database with the ODBC client (sqliteodb 0.992), I can see > 100% of the tables (I use QTADO as my interactive tool, and it doesn't show > triggers). 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.
My guess is that you're opening two different database files, with the same name but in different folders. Each program is assuming a different default folder. For debugging purposes, try specifying a full path including folder name in both of your programs. Or try ALTER TABLE x RENAME TO y in one of the applications and see if you can see the change when using the other application. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users