On Oct 15, 2008, at 10:11 PM, Roger Binns rogerb-at-rogerbinns.com | sqlite| wrote:
> The main cause of them failing is if the statement becomes > invalid. One example would be if it uses a collation that was > unregistered. I only use sqlite3_exec, so I don't keep prepared statements around. So does this mean that the schema change has to be happening between sqlite3_exec preparing and executing the statement? I also don't do any collation, and definitely no unregistration of collation. All the occurrences that I see are for the same "SELECT f1 AS f1, f2 AS f2 FROM t1" query. Since the application has lots of queries I'd expect to see this schema problem happen on some of the others, but at least so far I have not. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
