On 29 Aug 2014, at 9:20pm, jose isaias cabrera <jic...@cinops.xerox.com> wrote:
> Maybe is my lack of SQL knowledge, but I am finding myself having to > calculate and keep track of changes Why is the number of changes useful for you to know ? It's not the sort of thing that's useful in pure data manipulation. The ability to track changes is most useful in a multi-user or multi-program system, where one program caches some data. The program can keep a copy of total_changes() with the cache, and as long as total_changes() doesn't change, it knows its cache still holds accurate data. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users