Hello Igor, Thanks for the info.
Best regards, Kervin --- Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Kervin L. Pierre > <kervin-3GP3cpDhPzVWk0Htik3J/[EMAIL PROTECTED]> > wrote: > > The problem is, I don't know what > > 'invalidates' a prepared statement. In > > other words, when can I expect to have to > > 're-'prepare a statement? > > > > How long can I keep a prepared statement? > > Can they be passed between threads? I take > > it they are tied to a specific sqlite3_db* > > handle? Do starting new transactions, or > > transaction rollbacks, etc. affect them? > > Prepared statements are tied to a connection > (sqlite* handle). Since > SQLite connection cannot be shared between threads, > prepared statements > cannot either. A prepared statement is valid for the > lifetime of a > connection, with one exception: it becomes invalid > when database schema > changes, that is, when tables are created, altered > or dropped, when > triggers are created or dropped, and so on. > > Igor Tandetnik > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to > [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
