> > * Loop through values, calling sqlite3_bind_text on each of then: > rc = sqlite3_bind_text( my_db_stuff->stmt, my_db_stuff- > >current_position > + 1, local_buff, len, SQLITE_STATIC ); > > On the 1st call to the above, I get the return code 21, which I assume > is 'SQLITE_MISUSE' from searching around. If I call > sqlite3_errmsg(sqlite3_db) I get 'not an error'.
sqlite3_bind_text will return SQLITE_MISUSE if the statement handle passed as the first argument is invalid. Or if it is a valid statement handle that is currently executing. If you call sqlite3_step() to step a statement, then you have to call sqlite3_reset() before you can change the values of bound variables using sqlite3_bind_XXX(). Not clear why the call to sqlite3_errmsg() returns "not an error" though. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
