Hi Ryan,

On 2/2/2013 1:55 AM, Ryan Johnson wrote:
That would break sybase, though: the quotes would also tell it to treat the db name and periods as part of the table name, too:

sqlite3> create table foo(x,y);
sqlite3> .tables
foo
sqlite3> select * from "main.foo";
Error: no such table: main.foo

Since the OP (you aren't the OP, right?) seems to have control over the code, I wonder if a compile-time macro could be used to attach the quotes around the database name only in the test environment. But, otherwise, I think we're at the end of what can be done with SQLite.

Best Regards,
Mohit.



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to