"Richard Hipp" wrote...

On Tue, Jul 29, 2014 at 4:49 PM, jose isaias cabrera <cabr...@wrc.xerox.com>
wrote:


Is there a way to keep a count of the INSERTS/REPLACES that took place
between the BEGIN and END? I was looking into the SQL changes() function,

http://www.sqlite.org/lang_corefunc.html#changes

but wouldn't it have to be done after each INSERT?


Use the total_changes() function both before and after the transaction, and
take the difference between the two.

Thank you, Dr. Hipp.  Works like a charm.

josé
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to