How do I update an android sqlite database column value to null using ContentValues?

Question

For example, I want to do the following on a database update.

Is there a constant I can use instead of null, which won't compile if I use it like:

ContentValues args = new ContentValues();
args.put(KEY_RISK_AMOUNT, null); // what constant do I use instead of null?

I found the answer...I need to do this: args.putNull(KEY_RISK_AMOUNT) — steve
– steve, Commented Jun 4, 2011 at 1:48
You should answer your own question and come back tomorrow to mark it as the accepted answer if it works as intended. — Austyn Mahoney
– Austyn Mahoney, Commented Jun 4, 2011 at 2:05
I don't think I can answer my own question, at least I don't see how... — steve
– steve, Commented Jun 4, 2011 at 17:41

skolima · Accepted Answer · 2013-08-12 14:26:35Z

98

Use ContentValues.putNull(java.lang.String):

ContentValues args = new ContentValues();
args.putNull(KEY_RISK_AMOUNT);

edited Aug 12, 2013 at 14:26

answered Jun 26, 2011 at 14:20

skolima

32.9k28 gold badges121 silver badges154 bronze badges

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

3 Comments

Sogger Over a year ago

bonus points for answering this question when the o.p. already answered himself in the comments 20 days before your answer and then getting 10 upvotes! Nicely done :)

CodeReaper Over a year ago

Well, someone had to do it. :p

NAP-Developer Over a year ago

good answer... putNull easy to understand this method on content values class :)

Collectives™ on Stack Overflow

How do I update an android sqlite database column value to null using ContentValues?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related