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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to