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]
-----------------------------------------------------------------------------
