Raise value of integer column with ContentValues (Java, Android)

Question

I have an SQL Update statement like:

UPDATE table set column = column+1

Is it possible to do someting similiar with ContentValues?

ContentValues values = new ContentValues();

values.put("colum", ?);

I am not sure, but I think you could do this, try incrementing it — Murtaza Khursheed Hussain
– Murtaza Khursheed Hussain, Commented Apr 17, 2015 at 6:22

laalto · Accepted Answer · 2015-04-17 06:28:31Z

3

Is it possible to do someting similiar with ContentValues?

No. You can only put literals in ContentValues, not expressions.

Under the hood the values in ContentValues get translated to sqlite3_bind...() calls and sqlite3 parameter binding only supports replacing literals with parameters.

To use an expression, just use execSQL() with the raw SQL you have.

answered Apr 17, 2015 at 6:28

laalto

153k68 gold badges293 silver badges306 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

2red13 Over a year ago

Thank you, its a little bit sad, because i wantet to do something like if update()<1 then insert(), but then i have to split it into different commands

Collectives™ on Stack Overflow

Raise value of integer column with ContentValues (Java, Android)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related