How to update data in Sqlite?

Question

In my android application I am using sqlite database. I use the following code to update data but the data is not updated.

public int setCurrentLevel(int level)
{
  //update table level set currentlevel = level;
  int slevel = level;
  Log.d("QUIZ APP", "inside on setcreatelevel is "+slevel);
  ContentValues args = new ContentValues();
  args.put("currentlevel", slevel);

  return db.update("level", args, "currentlevel" + ">=" + slevel, null);
}

public int setCurrentLevel(int level) { //update table level set currentlevel = level; int slevel = level; Log.d("QUIZ APP", "inside on setcreatelevel is "+slevel); ContentValues args = new ContentValues(); args.put("currentlevel", slevel); return db.update("level", args, "currentlevel" + ">=" + slevel, null)>0; } — Harneet Kaur
– Harneet Kaur, Commented Jun 18, 2012 at 6:31
Use ContentValues for update. Have a look at this blog and use their example app — Praveenkumar
– Praveenkumar, Commented Jun 18, 2012 at 6:32
does the table have a default value? it needs to have atleast a single value where the currentlevel>= slevel. — PrincessLeiha
– PrincessLeiha, Commented Jun 18, 2012 at 6:45
In log it returns the slevel value. Database remains same as default value. — machu
– machu, Commented Jun 18, 2012 at 7:29

Vipul · Accepted Answer · 2012-06-18 06:49:05Z

2

Here you go

db.update("level",args,"currentlevel>= ?", new String[] { String.valueOf(level) });

edited Jun 18, 2012 at 6:49

answered Jun 18, 2012 at 6:44

Vipul

28.2k7 gold badges63 silver badges76 bronze badges

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

Comments

Om3ga · Accepted Answer · 2012-06-18 06:31:05Z

0

Use this kind of code inside your function

public boolean updateTitle(long rowId, String isbn,
String title, String publisher)
{
ContentValues args = new ContentValues();
args.put(KEY_ISBN, isbn);
args.put(KEY_TITLE, title);
args.put(KEY_PUBLISHER, publisher);
return db.update(DATABASE_TABLE, args,
KEY_ROWID + "=" + rowId, null) > 0;
}

answered Jun 18, 2012 at 6:31

Om3ga

33.4k46 gold badges149 silver badges231 bronze badges

1 Comment

machu Over a year ago

I have created the table sqlite manager tool, will it be a problem.

Harneet Kaur · Accepted Answer · 2012-06-18 06:32:24Z

0

Try This

    public int setCurrentLevel(int level)
   {
            //update table level set currentlevel = level;
            int slevel = level;
            Log.d("QUIZ APP", "inside on setcreatelevel is "+slevel);
            ContentValues args = new ContentValues();
            args.put("currentlevel", slevel);
             return db.update("level", args, 
                 "currentlevel" + ">=" + slevel, null)>0;

      }

answered Jun 18, 2012 at 6:32

Harneet Kaur

4,4971 gold badge18 silver badges16 bronze badges

Comments

Anu · Accepted Answer · 2012-06-18 06:42:26Z

0

use this query......... also mention some condition on which you want to fire this update

      db.execSQL("UPDATE "+tableName+" SET "+columnNameValue+" WHERE "+condition+"");

your query will look something like:

    db.execSQL("UPDATE level SET currentlevel="+slevel +" WHERE currentlevel \\>=" + slevel+"");

edited Jun 18, 2012 at 6:42

answered Jun 18, 2012 at 6:33

Anu

5623 silver badges9 bronze badges

Comments

Alberto · Accepted Answer · 2013-01-17 09:05:18Z

0

Try this,

ContentValues cv = new ContentValues();
cv.put("Field", value);
db.update("Table", cv, "Field='value'", null);

answered Jan 17, 2013 at 9:05

Alberto

113 bronze badges

Collectives™ on Stack Overflow

How to update data in Sqlite?

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related