Thanks for everyone's help. Unfortunately, as Ryan highlighted, the
double quotes around the table 'database..name' cannot be handled by
sybase. It's a shame as I rather like Sqlite and works soo well with Python.
All the best,
Marc
On 02/02/13 07:56, Mohit Sindhwani wrote:
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users