On 3/31/06, Matthew Gertner <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying to detect changes in our application schema and update the > corresponding database schema automatically, but only when the table in > question is actually needed (i.e. a sort of on-demand schema update). > The problem I'm having is when other statements are open when this > occurs, in which case I seem to be getting a "SQL logic error or missing > database" error when I try to run CREATE TABLE. >
Your statements must be prepared again after the schema changes. It's a limitation of the sqlite package.
