This happened to me before and it took a while to track down, but have a look at your threading model as well. What is the thread safety mode you have compiled with and how are you managing connections to databases across multiple threads? For me the gotcha was sharing and iterating through results of prepared statements on multiple threads on a connection that was not used in serialized mode (it was in threadsafe mode which means it worked MOST of the time, but every so often it would fail). The kicker is that sometimes the corruption was not even there (just reported by the API, but gone upon later inspection on the command line).
Jim Borden Software Engineer jim.bor...@couchbase.com _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
