[sqlite] how to reuse a prepaired statement

[Sam Carleton]

I am implementing a dataset update process.  There is a for loop going
through the dataset either doing an update on the row or deleting the
row.  So there are two statements that are preparied, currently I am
using the same basic logic for both.  The problem is the second time
around I get a SQLITE_MISUSE.

What am I doing wrong?

-------------------
stmtDelete = sqlite3_prepare_v2(...)

while( nextRecord())
{
  rc = sqlite3_bind_<type>(stmtDelete, ...);
  if( rc == SQLITE_OK) rc = sqlite3_bind_<type>(stmtDelete, ...);
  if( rc == SQLITE_OK) rc = sqlite3_bind_<type>(stmtDelete, ...);

  if( rc == SQLITE_OK)
  {
    rc = sqlite3_step(stmt);
    if( rc != SQLITE_DONE) LogError();
  }

  sqlite3_clear_bindings(stmt);
 }

sqlite3_finalize(stmt);
-------------------
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users