-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 09/26/2011 06:03 PM, yary wrote: > I noticed that the sqlite shell won't ".import" into an attached database:
The cause of the error message is a test in the shell code. It prepares this: SELECT * from 'tablename' I have no idea why it puts single quotes around the table name. If you do that then database names are not used. The table name is correctly quoted so it really makes no sense. sqlite> attach '/tmp/foo' as foo; sqlite> create table foo.bar(x); sqlite> select * from foo.bar; sqlite> select * from 'foo.bar'; SQLError: no such table: foo.bar Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk6Bo8wACgkQmOOfHg372QQ0+QCgqCr2wB19UqboO346U+pnzF7g tAcAoOHaEVZGnQequmfPZtXBsm7IEoXL =ZICf -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
