Re: [sqlite] help to get the value of file change counter

2011-09-13 Thread Michael Stephenson
Just a guess, but you may have to use one of the Pager functions to examine the buffer for database page 1, which is always pinned in memory and which represents the first bytes of the database file. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] help to get the value of file change counter

2011-09-13 Thread Akash Agrawal
hii thank you for suggestion. but when reading the value from sqlite header it printing same value no change i can see i pasting the c++ code below /CODE/ #include #include using namespace

Re: [sqlite] help to get the value of file change counter

2011-09-12 Thread Simon Slavin
On 12 Sep 2011, at 1:35pm, Richard Hipp wrote: > On Mon, Sep 12, 2011 at 8:02 AM, Igor Tandetnik wrote: > >> Simon Slavin wrote: >>> >>> >>> int sqlite3_total_changes(sqlite3*); >>> >>> My

Re: [sqlite] help to get the value of file change counter

2011-09-12 Thread Richard Hipp
On Mon, Sep 12, 2011 at 8:02 AM, Igor Tandetnik wrote: > Simon Slavin wrote: > > > > > > int sqlite3_total_changes(sqlite3*); > > > > My understanding (which might be wrong) is that this count includes

Re: [sqlite] help to get the value of file change counter

2011-09-12 Thread Igor Tandetnik
Simon Slavin wrote: > > > int sqlite3_total_changes(sqlite3*); > > My understanding (which might be wrong) is that this count includes all > changes made by all connections to that database: not > only changes made using

Re: [sqlite] help to get the value of file change counter

2011-09-12 Thread Akash Agrawal
this is very helpful for me thank you -- Regards Akash Agrawal On Mon, Sep 12, 2011 at 12:39 PM, Simon Slavin wrote: > > On 12 Sep 2011, at 5:08am, Akash Agrawal wrote: > > > I'd like to be able to tell whether a SQLite database file has been > updated > > in any way.

Re: [sqlite] help to get the value of file change counter

2011-09-12 Thread Simon Slavin
On 12 Sep 2011, at 5:08am, Akash Agrawal wrote: > I'd like to be able to tell whether a SQLite database file has been updated > in any way. How would I go about implementing that? > > I find about some file change counter but how i will get the value of file > change counter through C program

[sqlite] help to get the value of file change counter

2011-09-11 Thread Akash Agrawal
Hello, I'd like to be able to tell whether a SQLite database file has been updated in any way. How would I go about implementing that? I find about some file change counter but how i will get the value of file change counter through C program -- Akash Agrawal