[sqlite] reset after failed step

[Jan Danielsson]

Hello,

   Is this (conceptually) correct:

   -------------
   .. bind arguments ..

   sqlrc = sqlite3_step(stmt);
   if(sqlrc == SQLITE_ROW || sqlrc == SQLITE_DONE) {
     sqlrc = sqlite3_reset(stmt);
     assert(sqlrc == SQLITE_OK);
   }

   .. bind other arguments ..

   sqlrc = sqlite3_step(stmt);
   if(sqlrc == SQLITE_ROW || sqlrc == SQLITE_DONE) {
     sqlrc = sqlite3_reset(stmt);
     assert(sqlrc == SQLITE_OK);
   }

   sqlrc = sqlite3_finalize(stmt);
   assert(sqlrc == SQLITE_OK);
   -------------

   I.e. reset should only be run on ROW and DONE.  On step error, the
statement's state is reset implicitly by sqlite3_step()?

-- 
Kind regards,
Jan Danielsson

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users