On Jan 6, 2010, at 11:11 AM, Christopher Sansone wrote: > > repeat > sqlite3_prepare(db, sql, -1, p, sql); > repeat
Try inserting a call to sqlite3_reset(p) here > s := sqlite3_step(p); > until > s in (SQLITE_DONE, SQLITE_ERROR, SQLITE_MISUSE); > sqlite3_finalize(p); > until > sql is null; > > As it should, sqlite3_prepare() provides a single statement to be Since you are running simultaneously in multiple threads, you are likely getting SQLITE_BUSY returns as two threads try to write at the same time. This causes the sqlite3_step() to loop, but you have to run sqlite3_reset() in between each sqlite3_step() attempt. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users