On Mon, April 3, 2006 15:49, Chris Fletcher wrote: >> <http://sqlite.org/capi3ref.html#sqlite3_total_changes> > > Thanks - but this seems to give the number of changes during the > lifetime of a db session. With CGI the sessions will be short lived. > On a new session I want to know when the db was last modified (or > some other indication of changes).
Why not use a trigger on insert/update etc to update a table with one row and column, the time of last modification? Alternatively, ensure your INSERTs etc update that table when they are done modifying? -- RonWare.ORG - Precision Crafted Software http://ronware.org/ Reva Forth for Linux and Windows http://ronware.org/reva/