On Tue, May 11, 2010 at 11:28:14PM -0700, Matt Young scratched on the wall: > 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
Unless a database name is specifically given (i.e. .backup/.restore), in most cases the sqlite3 dot-commands only work on the "main" and "temp" database. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
