dimanche 26 avril 2015

Android update sql query is checking column name instead of row item

I am writing an simple update query to update the row in which the name value should equal "Oli". However when I run the code :

cr.update(PlayersProvider.contentUri, values, "name " + "=" + "Oli", null);

I get the error :

android.database.sqlite.SQLiteException: no such column: Oli (code 1): , while compiling: UPDATE players SET name=?,score=?,description=? WHERE name =Oli

This is the format of the table :

name description score

Oli Age 20 1

Mike Age 21 0

Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire