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
