On 22 Jul 2012, at 6:48pm, Kevin Martin <ke...@khn.org.uk> wrote: > Is the behaviour it will only run once guaranteed by any standard, or likely > to change in future/previous versions of sqlite?
It's not predictable, even in the current version. SQLite can choose to re-prepare a prepared statement. The clause on a statement can be reevaluated or not. Another process may choose to change the underlying data, causing everything to reevaluated. My best recommendation is not to depend on any behaviour not made obvious by the documentation. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users