"Simon Slavin" wrote...
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.
Thanks for your response, Simon. It's a long story, but your description is
somewhat how I am using it: to keep track of changes on two systems and
updating one system with the data of the other and making sure that they
amount of changes are the same. The application is a multiple user
environment and application. And, to make it complicated, we are moving
from one server to another, so there are two instances of the application
per user on two environment keeping track of the same data on two different
SharedDBs. In the end, there will only be one server, but until we close all
of the projects in the old server, the data from the old server is is being
pushed nightly to the new server. So, total_changes() has been my friend
since the end of July. I know that disconnecting the DBs and connecting
would reset the function, but, imho, it would be nice to have that simple
extra reset for situations like this. Thanks for this wonderful tool.
josé
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
