Thanks Clemens.
________________________________ From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of Clemens Ladisch <clem...@ladisch.de> Sent: Saturday, January 20, 2018 10:39:15 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] [EXTERNAL] get stmt row count x wrote: > is there an easy way of checking if the db file has been modified > since the RowIDs query has been run? The easiest way is to keep the transaction open, then you know that there have not been any modifications, as far as you can see. :o) > I’m sure I read something about a db related integer that was > incremented after every update or vacuum but can’t find the post. <http://www.sqlite.org/fileformat2.html#file_change_counter> <http://www.sqlite.org/pragma.html#pragma_data_version> | The integer values returned by two invocations of "PRAGMA data_version" | from the same connection will be different if changes were committed to | the database by any other connection in the interim. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users