On 2 Mar 2012, at 7:40pm, "Rose, John B" <jbr...@utk.edu> wrote:
>> So once again, how would you answer Roger's question ? Suppose changes were >> made on both computers at the same time. How would you reconcile the two >> copies of the databases ? If you want to use the copy from the computer to >> /update/ the copy in the mobile device then the mobile device needs access to >> /both/ copies of the database when it's doing the updating, so it can see >> what's new. So you really have not one database but two databases > > Changes would not be made on both at the same time. Initially you upload > your base DB on the mobile device, gather samples somewhere in field and > occasionally change/add/delete data. Come back to the lab and download the > latest version of the database. Then the lab staff uses the new updated > version until you go out again and repeat that sequence. Okay. In that case, if the data is stored in a SQLite database, then yes, the data can all be stored in one SQLite database file and all you need to know how to copy that file onto and off of your Android device. This doesn't need to have anything to do with how your sampling Android app accesses the file once it is on the device. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
