totalChanges



Determines the number of row changes caused by INSERT, UPDATE or DELETE statements since the database connection was opened.

Arguments: There are no arguments to this method.
Return value: Returns the number of row changes caused by INSERT, UPDATE or DELETE statements since the database connection was opened.
Remarks: The count returned bytotalChangesincludes all changes from all trigger contexts and changes made by foreign key actions. But, the count does not include changes used to implement REPLACE constraints, do rollbacks or ABORT processing, or DROP TABLE processing. The count does not include rows of views that fire an INSTEAD OF trigger, though if the INSTEAD OF trigger makes changes of its own, those changes are counted. The changes method can be used to get the number of changes caused by the most recent completion of a single SQL statement.
Details; The functionality of thetotalChangesmethod is similar to that of the SQLite sqlite3_total_changes API.