On 15 Aug 2009, at 3:57pm, Andrew Gatt wrote: > Simon Slavin wrote: >> On 15 Aug 2009, at 3:12pm, Andrew Gatt wrote: >> >>> but by my scheme you can't be sure if the list_1 table exists in >>> database2, >> >> Add a column to your 'lists' tables which says which database they're >> part of. So every row of the database will have the same value. >> > > Unfortunately the database names change (they are assigned as and when > the storage is attached)
Wait ... the first time the storage is attached ? Or each time you unplug then replug that storage ? Are the names of your databases changing ? Do you have some sort of automated system which works out which databases to open depending on which storage devices are attached ? > and also the list will only return all the > items if all the databases are present, a smaller subset otherwise. So > i'd still have to check if the tables in the databases existed - > wouldn't i? I think a solution would be to make another table which keeps track of which database is on which storage device, and keep that table in a consistent place which is always available. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
