Perhaps I misunderstood the question. It sounds like he has the sqlite* objects for the databases, but wants to be able to determine the database/filename associated with them so he can construct an ATTACH statement in another query.
So.. the question is.. given an sqlite*, can you determine the underlying database/filename? -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dušan Paulovic Sent: Monday, July 22, 2013 10:35 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] attaching databases programmatically Perhaps you can create new connection with multiple virtual tables reading from all connections. But it is hard work... 2013/7/22 Nelson, Erik - 2 <erik.l.nel...@bankofamerica.com> > I've got an application that allows the user to create an arbitrary > number of databases, either in memory or not. In my C++ program, I > have the handles and I'd like to attach them all together so the user > can execute queries against them. However, the only way that I've > found to do that is to use the "ATTACH" sql. The problem is that the > sqlite3* exist, but the databases aren't in any namespace accessible to the > "ATTACH" query. > > Is there some way to programmatically attach databases when all you > have are the sqlite3 handles? > > I've read the list history, most of the conversations about this are a > few years back. > > Thanks > > Erik > > ---------------------------------------------------------------------- > This message, and any attachments, is for the intended recipient(s) > only, may contain information that is privileged, confidential and/or > proprietary and subject to important terms and conditions available at > http://www.bankofamerica.com/emaildisclaimer. If you are not the > intended recipient, please delete this message. > _______________________________________________ > 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 This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential, proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distribution or other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have received this email in error, please notify the sender immediately and delete the original. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
