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

Reply via email to