Am I correct in understanding sqlite3_total_changes() doesn't include 
changes to the "master" tables, and thus won't reflect schema changes?

If so, is there any general way to determine -- given an arbitrary query 
-- whether or not it changed the database?

Basically, I'm creating a replay log and would like to filter out 
everything that doesn't change the database.  sqlite3_total_changes() 
appears to work as expected for everything except schema changes.  Is 
there any more general way to detect changes that would also catch 
schema changes?

Checking the modified date of the database might be one way, but that 
feels like a hack.  Any other ideas?

Thanks!

-david

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to