[sqlite] Strange behaviour of sqlite3_stmt_busy

[Simon Slavin]

On 31 Jul 2015, at 6:03pm, gwenn <gwenn.kahz at gmail.com> wrote:

> And do you recommend the strategy used in tclsqlite.c:
> 
>      rcs = sqlite3_step(pStmt);
>      if( rcs==SQLITE_ROW ){
>        return TCL_OK;
>      }
>      ...
>      rcs = sqlite3_reset(pStmt);
>      ...
> 
> 
> Reset the stmt as soon as possible after sqlite3_step (except on SQLITE_ROW) ?

Using _reset() or _finalize() releases resources.  If you're not going to need 
the statement again then _finalize() is better because it releases more 
resources.

Simon.