On 26 Mar 2012, at 4:23pm, Wu Jian <ravinw...@gmail.com> wrote: > I need to record these ids so that I can get and sync the changes with > server in the feature.
Have a routine which turns an 'UPDATE' command into a 'SELECT' command, and use that before you use the UPDATE. Or use TRIGGERs as Igor wrote. Or simply store the 'UPDATE' command somewhere and execute that on the server's database when you do the synchronising. However, note that two-way synchronisation is a minefield. I could write a book on the number of things you have to handle to get it right. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users