SQLite Update problem in Android

Question

I have tried to browse it here, but i couldn't find a solution. The problem is,

I have a database, and i want to update a column in the database, such that the updated value is 1 less than the previous.. Basically, in SQL, it UPDATE TABLE TNAME SET VAL=VAL-1 where

How do i do that in Android? I tried doing this

ContentValues args = new ContentValues();
args.put(KEY_ROWID, "KEY_ROWID-1");
db.update(DATABASE_TABLE, args, KEY_ROWID + ">0", null);

But this doesn't work.

I will be thankful if you can help me with this!

Nithin

score 2 · Answer 1 · answered Jul 12 '11 at 18:46

2

SQLiteStatement stmt = db.compileStatement("UPDATE TABLE TNAME SET VAL=VAL-1");
stmt.execute();

answered Jul 12 '11 at 18:46

Shane Wealti

2,162
3
18
32

I tried, it says "SQLiteStatement" cannot be resolved to a type! I don't understand why it says this – nithinreddy Jul 13 '11 at 02:34

score 1 · Accepted Answer · edited May 23 '17 at 12:11

1

If you already have a working SQL-syntax, there is no need to "build" it in Android. You can for example use a PreparedStatement (which accepts an SQL-String) and use your Query there.

A nice example can be found here.

edited May 23 '17 at 12:11

Community

1
1

answered Jul 12 '11 at 18:43

Lukas Knuth

24,328
14
80
107

SQLite Update problem in Android

2 Answers2