On Aug 14, 2008, at 4:18 PM, Brown, Daniel wrote: > Hello Stefan, > > I'm trying to use the code snippet you suggested but when I try to > query > the master table of the attached database I get and error with the > following message: > "SQL error: no such table: 'test.sqlite_master'; > > I am running the following queries: > 1. "ATTACH DATABASE 'data\\test.db' AS test" - this seems to succeed > (no > error code). > 2. "SELECT tbl_name FROM test.sqlite_master' WHERE type = 'table'" - > this one is failing. >
Works when I try it. But I'm not running on windows. Do you really need two backslashes in the filename? Should there be just a single backslash? You do not quote backslashes in SQL strings as you do in C. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users