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