Joanne Pham wrote:
> Hi Igor,
> I used SQLite versio n 3.5.9.
> I read the SQLite online document and the suggession that we need to finalize
> all the prepare statement associated with database connection before closing
> the connection as below
>
> while( (pStmt = sqlite3_next_stmt(pDb, 0))!=0 ){
> sqlite3_finalize(pStmt);
> }
> sqlSt= sqlite3_close(pDb);
> but the codes didn't return the syntax for sqlite3_next_stmt. Is
> sqlite3_next_stmt is valid command in SQLite 3.5.9
Yes, it is, see http://www.sqlite.org/c3ref/next_stmt.html for details.
It was introduced in 3.6.0 (see http://www.sqlite.org/changes.html), so
it was not present in 3.5.9.
HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
