RDbNamedDatabase execute leave -6 when update

mer, 2007-09-12 05:32

Joined: 2004-09-23
Forum posts: 46

I am using the RDbNamedDatabase, everything seems be ok except the update field=field+1
It leaves -6(Bad request ). From the debug windows:

SQLStatement:UPDATE filestore SET fseq=fseq+1 WHERE fid='20070912120624' AND fseq>0
CEng TextResolver: NewLC()
CEng TextResolver: ResolveError(aError(-6), aTextId(0), aFlags(0), aContext(3))
CEng TextResolver: ReadResourcesToArraysL(aError(-6), aTextId(0))
CEng TextResolver: PrepareReaderLC(reader)
CEng TextResolver: ReadUnicodeString(aTextBuffer(805306368), aTextId(2))
CEng TextResolver: ResourceForError(aError(-6))
CEng TextResolver: ReadUnicodeString(aTextBuffer(805306368), aTextId(20))

The table is :CREATE TABLE filestore (fid CHAR (60) NOT NULL, fname CHAR (60) NOT NULL,fseq UNSIGNED INTEGER,fmname CHAR (60) NOT NULL,fprice CHAR (60) NOT NULL,ftype UNSIGNED INTEGER, fcategory CHAR (60), fstatus UNSIGNED INTEGER,fdes CHAR (60), fowner UNSIGNED INTEGER)

TableIndex is :CREATE UNIQUE INDEX fstore_index ON filestore (fid, fname, fseq)

when i change the sql to :UPDATE filestore SET fseq=1 WHERE fid='20070912120624' AND fseq>0, it can work.

Is it the RDbNamedDatabase can not support field=filed +1 ???

- Report To Moderator -

mer, 2007-09-12 09:13
eric Joined: 2003-01-14 Forum posts: 2133	Looks like it don't as -6 is generally returned when the query is invalid. Use the C++ interface to do the select, read the data and update it as per your need. Eric Bustarret NewLC Founder & CEO / Professional Symbian OS Consultant - Report To Moderator -

mer, 2007-09-12 09:50

Ruchi-forum

Joined: 2006-09-15
Forum posts: 25

Hi ....

Please go through with this code ..
It may solve ur problem...

User::LeaveIfError(iTable.Open(iDbNamedDatabase, aTableName, iTable.EUpdatable));
CleanupClosePushL(iTable);

iTable.Reset();

CDbColSet* colset = iTable.ColSetL();
CleanupStack::PushL(colset );

TInt rowCount = iTable.CountL();
for(TInt i=0;iCount();i++)
{
iTable.Reset();
iTable.InsertL();
iTable.SetColL(colset ->ColNo(_L("RowId") ), ++rowCount );
}
}

CleanupStack::PopAndDestroy(colset );

CleanupStack::Pop();
iTable.Close();

Ruchi.

- Report To Moderator -

mer, 2007-09-12 10:12
Ruchi-forum Joined: 2006-09-15 Forum posts: 25	or you can make use your query like .. _LIT( KText1,"UPDATE filestore SET fseq='" ); _LIT( KText2, " fid='20070912120624' AND fseq>0" ); TBuf<256> sqlQuery; _LIT( KFormatString, "%S%D%S" ); sqlQuery.Format( KFormatString,&KText1,++fseq,&KText2); sqlQuery.TrimAll(); iDbNamedDatabase.Execute( sqlQuery ); Hop this ll solve your problem... Ruchi. - Report To Moderator -

jeu, 2007-09-13 08:21

agirllikeyou

Joined: 2004-09-23
Forum posts: 46

Thanks, it is solved. code is here:

void CDBMSengine::UpdateOtherSeqsL(TInt aIncreaseDecrease)
{
 
        TInt ret;
        RDbs dbSession;
        User::LeaveIfError( dbSession.Connect() );
        CleanupClosePushL( dbSession );
        RDbNamedDatabase database;
        ret = database.Open( dbSession, KDatabaseName );
        if ( ret != KErrNone )
                {
                CEikonEnv::Static()->InfoWinL( _L("Information"), _L("Please create database first!"));
                CleanupStack::PopAndDestroy(); // dbSession
                return;
                }

    CleanupClosePushL( database );

        database.Begin();
 
        RDbView Myview;

        _LIT(KSQLQuery, "SELECT * FROM filestore WHERE fid = ");
        _LIT( KAnd1, " AND fseq >= " );
        _LIT( KOrder, " ORDER BY fseq" );
    TBuf<KMaxSQLLength>  SQLStatement;
    SQLStatement = KSQLQuery;
        SQLStatement.Append( KSQLQuote1 );
        SQLStatement.Append( iFid );
        SQLStatement.Append( KSQLQuote1 );

        SQLStatement.Append( KAnd1 );        
        SQLStatement.AppendNum( iFSeq );
        SQLStatement.Append( KOrder );
RDebug::Print(_L("SQLStatement:%s"),SQLStatement.Ptr());
        Myview.Prepare(database, TDbQuery(SQLStatement));
        CleanupClosePushL(Myview);
        Myview.EvaluateAll();
        Myview.FirstL();
        TInt i = iFSeq;
        while(Myview.AtRow()) 
        {        
                if (aIncreaseDecrease == 1)
                {
                        i++;
                        Myview.UpdateL();
                        Myview.SetColL(5, i);
                }
                else if (aIncreaseDecrease == 0)
                {
                        Myview.UpdateL();
                        Myview.SetColL(5, i);
                        i++;
                }
                Myview.PutL();        
                Myview.NextL();
        } 
        
        CleanupStack::PopAndDestroy(1); // Myview
        User::LeaveIfError( database.Commit() );                        
        User::LeaveIfError( database.Compact() );

    CleanupStack::PopAndDestroy(); // pop and close database
    CleanupStack::PopAndDestroy(); // pop and close dbSession
}

- Report To Moderator -