Hi All,

I`m trying to update a table in my database using the following code


     _LIT(KSQLUpdate," UPDATE ConfigSettings SET Source=%S, Target=%S,
Audi=%d" );
     TBuf< 100> * tmpText=new(ELeave) TBuf< 100> ();
    CleanupStack::PushL(tmpText);
    tmpText-> Format(KSQLUpdate,& (iModel-> Source()),& (iModel->
Target()),iModel-> Audi);
   iEngineDB.Execute(*tmpText);
  CleanupStack::PopAndDestroy(tmpText);

Whenever I run this code I get an error saying Bad request.
I have gone through several other posts and all of them have used a SELECT
SQL query within a view in order
to update data within the table.

Is the usage of Update SQL Statement wrong here or do I have to use the
Update statement differently?
Is the updation of table only allowed through SELECT SQL query? Can`t I use
the update statement directly similar
to the INSERT statement?

Any help in this regard will be greatly appreciated.

Thanks & regards,
Asheesh