On 26 Mar 2010, at 10:47am, Akbar Syed wrote: > Unfortunately, my application restricts me to use independent > databases than to a single database > as each database exists on a different device and contains the info of > that device in the database. > Multiple devices are allowed to connect to my server app which instead > gathers the records from the > independent databases by attaching the databases together.
Make one big 'working' database by reading all the data from the databases on the independent devices and putting it into one big table. Once you have sucked out the data you can disconnect from the device. Then do all your enquiries on this big table. There's a special convenient form of the INSERT command which gets its data directly from a SELECT command: INSERT INTO bigTable SELECT * FROM attachedDB.myTable So, in a simplified example, for each pluginnable device do this: ATTACH "deviceFile.s3" AS attachedDB INSERT INTO allDeviceTable SELECT * FROM attachedDB.myTable DETACH attachedDB Then just query allDeviceTable. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
