Sorry for top post, client site forces worthless MS email on me. "Works" would require a politician dictionary. ":memory:" is a one-shot wonder. The example from the documentation allowed multiple threads to use the _same_ in memory database.
________________________________________ From: [email protected] on behalf of Simon Slavin Sent: Friday, May 24, 2013 4:11 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Correct way to open multiple in memory databases On 24 May 2013, at 7:06pm, Stephan Beal <[email protected]> wrote: > On Fri, May 24, 2013 at 5:03 PM, Roland Hughes > <[email protected]>wrote: > >> "file:memdb1?mode=memory&cache=shared", >> >> It ends up creating files in the executable directory. > > Have you tried using ":memory:"? Each instance of an in-memory db opened > that way is unique, despite the non-unique name: Yes, Roland, please check to see whether this works. It won't give you shared cache but it's a good test to figure out what's wrong. The example Roland used, by the way is straight from the SQLite documentation: <http://www.sqlite.org/inmemorydb.html> near the bottom. That's probably why he feels it should work. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
