Hmmmm...I duplicated this behavior on 3.6.23.1...I can only assume this is by intent as the interpreter isn't designed for mulitiple attached databases. .dump doesn't work on an attached table either Michael D. Black Senior Scientist Northrop Grumman Mission Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of Matt Young Sent: Wed 5/12/2010 1:28 AM To: General Discussion of SQLite Database Subject: [sqlite] Attach C:\R\SQLite>sql ap.data.3.Food.db SQLite version 3.6.23.1 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables Col2 U seriesdata seriesid sqlite> .q C:\R\SQLite>sql SQLite version 3.6.23.1 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> attach 'ap.data.3.Food.db' as d; sqlite> .tables sqliite> sqlite> select * from seriesid limit 2; APU0000701111|2|364 APU0000701311|365|388 sqlite> Case one, I attach the database on invocation, tables can be seen Case two, I open with attach command, no tables. Is it the quotes. In the second case I can still read data _______________________________________________ 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
