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