>Mohit wrote: >Can you use double quotes in the query? In this case no problem, double quotes are ignored around a tbl_name
sqlite> create temp table "db..test"(c1 integer, c2); sqlite> insert into "db..test" values (1, 'sqlite_temp_master'); sqlite> insert into "db..test" values (2, 'db..test'); sqlite> .width -8 20 sqlite> select * from "db..test"; c1 c2 -------- -------------------- 1 sqlite_temp_master 2 db..test sqlite> select rootpage, type from "sqlite_temp_master" where tbl_name = 'db..test'; rootpage type -------- -------------------- 2 table Cordiali saluti/Vriendelijke groeten/Kind regards, http://innocentisart.net _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
