On Fri, May 8, 2015 at 8:20 PM, Simon Slavin <slavins at bigfraud.org> wrote: > Suppose you have this statement > > DELETE FROM myTable WHERE id=600 > > and there are no rows with id=600. I presume that the function will return > FALSE but a literal reading of the description says that it will return TRUE. > If I'm right then it might be useful to rewrite the documentation a little.
I don't think sqlite_stmt_readonly does that. If you want to know if a statement has actually written to the database, call sqlite_total_changes before and after executing the statement, and compare their return values. Make sure you don't run other statements or write operations on the database during that time. -- Ambrus
