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

Reply via email to