Is there any way to use the PRAGMA database_list in a query? What I would like to do is:
SELECT * FROM (PRAGMA database_list) WHERE name = 'EventDB'; Sam On Sun, Jul 18, 2010 at 11:56 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 19 Jul 2010, at 4:48am, Sam Carleton wrote: > > > It would appear that the ATTACH/DETACH DATABASE is connection specific, > > correct? (It is logical now that I think about it.) > > Right. You could have a.db open in two connections. One connection might > also ATTACH b.db. That wouldn't do anything to the other connection. > > > A: Find out of a connection it attached to a DB such as EventDB? > > See > > PRAGMA database_list; > > in > > http://www.sqlite.org/pragma.html > > Simon. > _______________________________________________ > 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