Dan Kennedy <[EMAIL PROTECTED]> wrote: > > Another proposal: Suppose that when creating an > > sqlite3_stmt using sqlite3_prepare, the original SQL > > text was stored in the sqlite3_stmt. Then when a > > schema change occurred, the statement was automatically > > recompiled and rebound. > > The authorization callback > would have to be reinvoked from within sqlite3_step() too.
Yikes! I didn't think of that. This is pretty big negative and will likely scuttle plans to do automatic re-prepare. -- D. Richard Hipp <[EMAIL PROTECTED]>