updating sqlite database using a String not working

Question

This works but i need to be able to change the value of the product_name

String query = "UPDATE UserTable SET _quantity=_quantity - 1 WHERE product_name ='Hammer'";
myDatabase.execSQL(query);

This does not work and I can't see why.

String test = "Hammer";
String query = "UPDATE UserTable SET _quantity=_quantity - 1 WHERE product_name ='%"+test+ "%'";
myDatabase.execSQL(query);

the % symbol is to match anything like what he wants %amme% would match hammer — Rawr
– Rawr, Commented Oct 26, 2013 at 11:24
its just for testing that I have the String test set to Hammer. — John Snrub
– John Snrub, Commented Oct 26, 2013 at 11:24

android_dev · Accepted Answer · 2013-10-26 11:31:43Z

1

Try this code

i think it will work

ContentValues data = new ContentValues();
data.put("Column Name", column_value);

i.e,

data.put("_quantity", 3);

myDatabase.update(TABLE_NAME ,data,"product_name = ?",new String[]{test});

answered Oct 26, 2013 at 11:31

android_dev

1,48712 silver badges18 bronze badges

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

Comments

Bismark Ito · Accepted Answer · 2013-10-26 11:29:44Z

0

To match a pattern you should use the LIKE statement:

String test = "Hammer";
String query = "UPDATE UserTable SET _quantity=_quantity - 1 WHERE product_name LIKE '%"+test+ "%'";
myDatabase.execSQL(query);

answered Oct 26, 2013 at 11:29

Bismark Ito

6516 silver badges8 bronze badges

Comments

GrIsHu · Accepted Answer · 2013-10-26 11:48:26Z

0

You need to remove % symbols from your query. This symbols are used to match the strings values if you want to match anything like what he wants %mer% would match hammer

Try as below:

String query = "UPDATE UserTable SET _quantity=_quantity - 1 WHERE product_name ='"+test+ "'";

answered Oct 26, 2013 at 11:48

GrIsHu

23.6k9 gold badges62 silver badges96 bronze badges

Collectives™ on Stack Overflow

updating sqlite database using a String not working

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related