In the paragraph explaining: SQLITE_FCNTL_DATA_VERSION found here:
https://www.sqlite.org/draft/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntldataversion
(Suggested edits indicated like *this*)
...// The sqlite3_total_changes()
<https://www.sqlite.org/draft/c3ref/total_changes.html> interface can be
used to find if any database on the connection has changed, but that
interface respon*ds* to changes on TEMP as well as MAIN and does not
provide a mechanism to detect changes to MAIN only. Also, the
sqlite3_total_changes()
<https://www.sqlite.org/draft/c3ref/total_changes.html> interface
respon*ds* to internal changes only and omits changes made by other
database connections. The PRAGMA data_version
<https://www.sqlite.org/draft/pragma.html#pragma_data_version> command
provide*s* a mechanism to detect changes to a single attached database
that occur due to other database connections, but omits changes
implemented by the database connection for which it is called. This file
control is the only mechanism to detect changes that happen either
internally or externally*,* on a single database.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
