sqlite3 - SQL Upload syntax -

i'm struggling update query work.

i've tried:

"update status set status (status, color) values (@0, @1) id=@2" "update status set status (status, color) values (@0, @1) (id) values(@2)" 

however when insert, works:

"insert status (id, status, color) values (@0, @1, @2)" 

any suggestions?

thanks!

string sqlcommand = "update status set status (status, color) values (@0, @1) (id) values(@2 )";                     list<string> sqlcommandargs = new list<string>(new string[] {                          (statustextbox.text.first().tostring().toupper() + statustextbox.text.substring(1)),                         color,                         ((status)(statuslistbox.selecteditem)).statusid.tostring()                     });                     sqlloader.insertrowsqldatabase(sqlcommand, sqlcommandargs); 

fields updated assignments separated commas.

update status set status = @0, color = @1 id=@2 

read more: update statement in sqlite