Re: [sqlite] SQLITE_SCHEMA and statement parameters

[Jan-Eric Duden]

Vladimir Vukicevic wrote:
On 4/21/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
 

How about sqlite3_transfer_bindings().  So if you get an
SQLITE_SCHEMA error you rerun sqlite3_prepare() to get
a new sqlite3_stmt, then call sqlite3_transfer_bindings()
to transfer bindings from the old statement over to the
new statement.  Then sqlite3_finalize() the old statement.
   

That would work, except right now you only get SQLITE_SCHEMA from
sqlite3_finalize() -- sqlite_step just returns SQLITE_ERROR.  If
step() returned SQLITE_SCHEMA(), transfer_bindings() would work well,
or even if there was another method to return the same error that
finalize() returns (without destroying the statement).
Thanks,
   - Vlad
 

I use the sqlite3_expired api - which is only documented in the 
sqlite3.h header.
Unfortunately it is considered an experimental API.