On 19 Jul 2010, at 6:27am, Sam Carleton wrote: > Is there any way to use the PRAGMA database_list in a query?
I don't think so. It's not standard SQL, it's a freak of SQLite. Do what you want to do in software. If you're just checking to see if a known database is attached, you could try something like PRAGMA table_info(EventDB.knownTableName); If you get a sensible result back, it's there. If you get an error or blank (I don't know which it does), it's not attached. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
