How to increment field in sqlite android database

Question

Hey, I want to increment a column in a sqlite android database. Im doing like this:

public void atualiza(String word){
   this.db.rawQuery("UPDATE words SET count = count + 1 WHERE word= ? ", new String[] {word});     

}

And I call this method on another class like this:

this.dh.atualiza(word); 

But when i pull the database from the emulator and check with the SQLite Database Browser, the field is not incremented. Why?

Answer 1

You need to start a transaction on the database http://stackoverflow.com/questions/3483123/data-not-inserting-in-sqlite-database-in-android/3486373#3486373

Answer 2

You should really use execSQL for a query that does not return a table: http://stackoverflow.com/questions/3427516/increase-the-value-of-a-record-in-android-sqlite-database/3432777#3432777