[sqlite] UPDATE problem.

[lilezek]

Hi. I'm using SQLite in my own c++ aplication. Everything works except if I try 
to do this query:

UPDATE rnc_accounts SET lastip = '127.0.0.1' WHERE name = 'lilezek';

But when I do step I got always 5 (SQLITE_BUSY). You'll think the problem is 
mine, but I change the query to the next one:

SELECT * FROM rnc_accounts WHERE name = 'lilezek';

And it works fine. Any idea? Maybe you need more data. I attach a couple of 
functions. They are similar, the first one does not work, but the second one 
does:

//db::CreateDB creates db if not exist
//typedef string db::Query so db::Query means string
//db::OpenDB opens database
//db::CloseDB close database
//db::DoStep(sqlite_stmt,char *) do step on sqlite_stmt and returns a whole 
row. The column_count is set on the second argument
//db::DoQueryRequest(string, char *) prepares the first argument and  return 
sqlite_stmt. Also set the unprocessed query to char *.

//This function does not work. When I do Step, always sql is busy.
static bool UpdateIP(string Name, string Ip)
{
    db::faname AccountsFileName; 
    db::fcname Path = db::GetExecPath();
    strcpy(&AccountsFileName[0],Path);
    strcat(&AccountsFileName[0],"accounts.db");
    //(curdir)/accounts.db
    db::CreateDB(&AccountsFileName[0]);
    if (db::OpenDB(&AccountsFileName[0])!= 0)
        return false;
    db::Query qry;
    qry = "UPDATE rnc_accounts SET lastip = ";
    qry += db::SqlStr(Ip);
    qry += " WHERE name = ";
    qry += db::SqlStr(Name);
    qry += " ;"; 
    char Datacount,* UPQ;
    UPQ = new char[100];
    while(qry != "")
    {
        db::DoStep(db::DoQueryRequest(qry,UPQ),&Datacount);
        qry = UPQ;
    }
    db::CloseDB();
    return true;
}

//But this function works perfectly:
static bool CheckPassword(string Name, string Pass)
{
    db::faname AccountsFileName; 
    db::fcname Path = db::GetExecPath();
    strcpy(&AccountsFileName[0],Path);
    strcat(&AccountsFileName[0],"accounts.db");
    //(curdir)/accounts.db
    db::CreateDB(&AccountsFileName[0]);
    if (db::OpenDB(&AccountsFileName[0])!= 0)
        return false;
    db::Query qry;
    qry = "SELECT pass FROM rnc_accounts WHERE name = ";
    qry += db::SqlStr(Name);
    qry += " ;";
    string * queryresult;
    char * Datacount,* UPQ;
    Datacount = new char[1];
    UPQ = new char[100];
    while(qry != "")
    {
        queryresult = db::DoStep(db::DoQueryRequest(qry,UPQ),Datacount);
        qry = UPQ;
    }
    bool result;
    if(Datacount[0] > 0)
        result = (Pass.compare(queryresult[0]) == 0);
    else
        result = false;
    db::CloseDB();
    return result;
}
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users