Problem with android UPDATE

Question

I got a problem when it comes to giving update in a table on Android/SqLite:

I tried both ways I found:

String query = "UPDATE MY_TABLE SET VALUE1='VALUE1'... WHERE KEY_ID = KEY_ID"
SQLiteDatabase db = dbHelper.getWritableDatabase();
db.execSQL(query);

ContentValues values = new ContentValues();
values.put("VALUE1",VALUE1);
.
.
.
db.update("MY_TABLE",values,"KEY_ID="+KEY_ID,null);

Neither of the two ways is giving error, compile normally but the values are not updated in the database. I’ve debugged the application and the values are coming correctly in the method, but it just doesn’t update. When I recover the data again are without the modifications. Does anyone know what might be occurring?

Answer 1

Try it this way:

db.update("MY_TABLE", values, "KEY_ID = ?", new String[]{String.valueOf(KEY_ID)});

According to the documentation:

You can include ? in the WHERE clause, which will be replaced by values of the fourth parameter. Values will be linked as Strings.