android SQLitedabase update

Question

How to write the following command into sqlitedatabase update() function ?

String query="update " + TABLE_TASKS + " SET " + TASK_LEFT + "=CASE WHEN " + TASK_LEFT + ">= " + left +" THEN " + TASK_LEFT + "+2 ELSE " + TASK_LEFT + " END, " + TASK_RIGHT + "=" + TASK_RIGHT + " +2 WHERE " +TASK_RIGHT +" >= " + right;

Basically I want to know how to insert multiple clauses and WHEN THEN clauses into update() function?

http://stackoverflow.com/questions/9453651/conditional-update-in-sqlite — Anukool, Feb 15 '13 at 09:59
i wanted to know how to do that in android.database.sqlite.update() function — vikas, Feb 15 '13 at 10:09
yes it is working fine with execSQL, the query String I showed is of the execSQL(). I just wanted to know how to use update() function. — vikas, Feb 15 '13 at 10:21

score 0 · Answer 1 · answered Feb 15 '13 at 11:36

The update method takes the new values as a ContentValues object, which contains only fixed values. It does not allow reading old values from the database in the same step.

If you want to write SQL that is more complex than update allows, you have to use execSQL instead.

android SQLitedabase update

1 Answers1