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

Reply via email to