Getting all changes within a begin; end; transaction
Jose Isaias Cabrera <[email protected]> Wed, 4 Mar 2020 14:37:56 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <VI1P195MB0654A0BFCAFE637AA16EF6F2DEE50@VI1P195MB0654.EURP195.PROD.OUTLOOK.COM> |
Greetings. Imagine this SQL, BEGIN TRANSACTION; ... changes to records ... END; When I execute "int result = sqlite3_changes(database);" after that SQL execution, I always get 1. I think that it is because it is only providing the result of the last statement that was successful within the BEGIN-END transaction. I know that in all cases there should be many more than 1. Is there a way to know all the changes that may have happened within the full BEGIN and END? Thanks. josé _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users