Update Query not working in Android Sqlite

Question

My Java code Update Data base Table

String qq="UPDATE ChallanItems SET Recieve ="+str+" WHERE ItemNo = "+code;
                    Log.d("Qry", qq);
                     myDbHelper.updatequery(qq);

updatequery method

public void updatequery(String qry)
    {
        Cursor c = myDataBase.rawQuery(qry, null);


        Log.d("Up", ""+c.getCount());
    }

When i updated Data base the count return 0 and table not updated

I am using this Also but not work

String qq="UPDATE ChallanItems SET Recieve ="+str+" WHERE ItemNo = "+"'"+code+"'";

Please Help Me how i can fix this problem

Thanks In Advance

use sqLiteDatabase.update(YOUR_TABLE, where clause, YOUR_VALUES);. YOUR_VALUES is the object of ContentValues — Aniruddha
– Aniruddha, Commented Jun 2, 2014 at 7:17

laalto · Accepted Answer · 2014-06-02 07:10:37Z

7

Use execSQL() for such SQL and not rawQuery().

rawQuery() just compiles the SQL but does not run it. You'd need to call one of the move...() methods on the returned Cursor to execute a step of the compiled SQL program.

execSQL() both compiles and runs the SQL program.

There's also possibly a syntax problem with your literals - use parameters i.e. ? placeholders in SQL and String[] bind arguments to be safe.

answered Jun 2, 2014 at 7:10

laalto

153k68 gold badges293 silver badges306 bronze badges

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

Comments

Giru Bhai · Accepted Answer · 2014-06-02 07:15:51Z

2

To update sqlite query change

 Cursor c = myDataBase.rawQuery(qry, null);

to this

myDataBase.execSQL(qry);

answered Jun 2, 2014 at 7:15

Giru Bhai

14.4k5 gold badges50 silver badges74 bronze badges

Comments

Mohammad Rababah · Accepted Answer · 2014-06-02 07:14:24Z

1

try to use this:

ContentValues values = new ContentValues();
values.put("Recieve", str);
db.update("ChallanItems", values2, "ItemNo = ?", new String[] { code });

answered Jun 2, 2014 at 7:14

Mohammad Rababah

1,7264 gold badges17 silver badges33 bronze badges

Collectives™ on Stack Overflow

Update Query not working in Android Sqlite

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