Unfortunately part of the process does require us to run queries joining the server and local data :-( We make life complicated for ourselves !
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Monday, October 17, 2011 1:32 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] opinion on possible bad effects from detachingdatabase whilst statements prepared on it. On 17 Oct 2011, at 1:22pm, O'Neill, Owen wrote: > the application is distributed, so while it is running it > re-syncronises it's state with the server by recieving a copy of the > server's database. At this point it detaches it's current mounted > database and mounts the new file. It has a local database with local > settings which is the applications 'main' database connection with the > copy of the server's database mounted from that via the attach command. Unless you actually have relations between tables in the two separate databases, I think I'd recommend that you open the two databases on separate connections rather than attach one to the other. 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