On 21 Jul 2010, at 12:42am, Sam Carleton wrote: > There are two equally > important requires, one is to connect to the second "EventDB", the other is > that the system admin can change the EventDB at any time.
You mean change the contents of that file, or change which file is nominated as the EventDB file ? > The second > requirement means that connection can be attached to a database called > EventDB, but it is the wrong (old) DB. What signifies the 'right' EventDB ? Are you creating at least two different files (a right one and a wrong one) and giving them the same filename in the same directory ? If they're different files they should have different filenames. It seems to me that you either need to attach an EventDB file only as long as a command is trying to use it. If you can't do that you need a way to tell your application that the EventsDB file it's currently connected to is out of date, and it's time to go find a new EventDB file. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
