Do you think this is causing my problem?
I've added reset call there because without that this error was more frequent.
[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
