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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users