I'm using some wrapper but modified.
Here is my Exec method:

while(1)
{
        rc = _sqlite3_step(m_stmt);
        
        if (rc == SQLITE_ROW)
                return 1;
                
        if (rc == SQLITE_DONE)
        {
                _sqlite3_reset(m_stmt);
                return 0;
        }

        if ( rc == SQLITE_BUSY)
        {
                Sleep(0);
                rc = _sqlite3_reset(m_stmt);
                continue;
        }

        break;
}



Date: Mon, 8 Sep 2008 10:07:57 -0400
From: "Jeffrey Becker" <[EMAIL PROTECTED]>
Subject: Re: [sqlite] Error A0A
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Message-ID:
<[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1

Are you using the native api or one of the wrappers?

On Mon, Sep 8, 2008 at 9:58 AM, Dan <[EMAIL PROTECTED]> wrote:
>
> On Sep 8, 2008, at 1:47 PM, [EMAIL PROTECTED] wrote:
>
>>
>> I'm using multiple connections to sqlite database from more threads
>> in my application. Few customers reports sqlite error in windows
>> vista which I cannot get in my system.
>> Error code is 0xA0A (I haven't turned on extended error codes).
>> This error number gives no sense to me because it is not defined in
>> extended error codes too.
>> Most of times it occurs when I'm trying to run "Commit" command,
>> sometimes while SELECT.
>> Anybady knows what can be the problem?
>
> 0xA0A is SQLITE_IOERR_DELETE. Indicates a delete operation has
> failed. Could be something to do with anti-virus software preventing
> a journal file from being deleted.
>
> Dan.
>
>

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to