[EMAIL PROTECTED] wrote: > I'm using some wrapper but modified. > Here is my Exec method: > > > if ( rc == SQLITE_BUSY) > { > Sleep(0); > rc = _sqlite3_reset(m_stmt); > continue; > } >
You should not be resetting the prepared statement on a busy return. You should simply sleep and then continue to retry. If you want to ensure you don't loop forever, you could add a retry counter and do a reset and return if the retry limit is exceeded. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users