Hi Marc,
On 1/2/2013 10:42 PM, message adams wrote:
My applications actually run against sybase, but I'd love to use a
connection to an in-memory sqlite to carry out my testing.
As part of the unit-test, I'd pass the sqlite conenction into my source
code hoping it would be none the wiser.
The only real problem I see, is sybase uses a double period separator
between the database and table. e.g.
select * from database..table
... whereas sqlite
select * from database.table
Can you use double quotes in the query?
For example, this works in SQLite3
sqlite> create table "db..abc"(p INTEGER, q INTEGER);
sqlite> .tables
db..abc
sqlite> select * from "db..abc";
sqlite>
Best Regards,
Mohit.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
