This might be redundant, but:
http://www.sqlite.org/faq.html#q17
As was mentioned earlier in the thread, for non-intuitive reasons
a VACUUM command counts as modifying the schema.
For maximum robustness, every time an SQL statement is executed using
the prepare()/reset()/finalize() API the code should handle the
SQLITE_SCHEMA error.
Dan.
--- Demitri Muna <[EMAIL PROTECTED]> wrote:
> On the subject of "database schema has changed" error messages....
> I'm getting the same whenever I try to use precompiled queries in
> 3.2.1. Is anyone else seeing the same thing? Is there a reason that
> this should be happening? Taking the time to close/reopen the db
> seems to defeat the purpose of precompiling the query.
>
> Cheers,
>
> Demitri
>
__________________________________
Discover Yahoo!
Find restaurants, movies, travel and more fun for the weekend. Check it out!
http://discover.yahoo.com/weekend.html
