Sqlite database updating a row android

Question

I am developing an android app, in which I need update a column in a table based on the a certain where clause.Here is the code below,

public void updatethekeyofweeklycolumn(String profilename, String keystemp) 
{
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();

    values.put(Profile_keysofweekly, keystemp);

    db.update(TABLE_PROFILE_SETTINGS_FOR_WEEKLY, values,Profile_Name_for_weekly +" = "+profilename, null);
}

The above code is working fine with where clause as null, but its throwing a force close with the whereclause is set. Is my Query wrong?

Dude, why don't you accept the answers people give you? It's not like you're supposed to give them money ... — gunar
– gunar, Commented Sep 23, 2013 at 13:03
I have not much knowledge about the api's of stack exchange. All I do is ,vote up if the answer is useful, and accept the answers if its right. I cant accept answers which doesnt work and misguide others , even if I am not paying money right? :) .If the answer turns out right, I would surely appretiate the help. Sorry man, no acceptance for a wrong answer from my side. — Dave
– Dave, Commented Sep 24, 2013 at 12:19

Pankaj · Accepted Answer · 2016-01-24 10:39:16Z

14

You need to escape profilename. So you either add the single ' character:

db.update(TABLE_PROFILE_SETTINGS_FOR_WEEKLY, values,Profile_Name_for_weekly +" = '"+ profilename + "'", null);

Or, the option I would follow:

db.update(TABLE_PROFILE_SETTINGS_FOR_WEEKLY, values,Profile_Name_for_weekly +" = ?", new String[] {profilename});

edited Jan 24, 2016 at 10:39

Pankaj

8,0787 gold badges46 silver badges69 bronze badges

answered Sep 23, 2013 at 12:59

gunar

14.7k7 gold badges61 silver badges88 bronze badges

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

1 Comment

RAW Over a year ago

shouldn't it be db.update(TABLE_PROFILE_SETTINGS_FOR_WEEKLY, values,Profile_Name_for_weekly +" = ?", new String[] {profilename}) ?

Suragch · Accepted Answer · 2015-01-08 02:26:03Z

For more general help in understanding how to update a database row, the documentation was actually helpful this time:

SQLiteDatabase db = mDbHelper.getReadableDatabase();

// New value for one column
ContentValues values = new ContentValues();
values.put(FeedEntry.COLUMN_NAME_TITLE, title);

// Which row to update, based on the ID
String selection = FeedEntry.COLUMN_NAME_ENTRY_ID + " LIKE ?";
String[] selectionArgs = { String.valueOf(rowId) };

int count = db.update(
    FeedReaderDbHelper.FeedEntry.TABLE_NAME,
    values,
    selection,
    selectionArgs);

This page was also helpful: Working with SQLite Database (CRUD operations) in Android

In my case I made a method like this:

public long updateTime(long rowId) {

    // get current Unix epoc time in milliseconds
    long date = System.currentTimeMillis();

    SQLiteDatabase db = helper.getWritableDatabase(); // helper is MyDatabaseHelper, a subclass database control class in which this updateTime method is resides
    ContentValues contentValues = new ContentValues();
    contentValues.put(MyDatabaseHelper.DATE_TIME, date); // (column name, new row value)
    String selection = MyDatabaseHelper.ID + " LIKE ?"; // where ID column = rowId (that is, selectionArgs)
    String[] selectionArgs = { String.valueOf(rowId) };

    long id = db.update(MyDatabaseHelper.FAVORITE_TABLE_NAME, contentValues, selection,
            selectionArgs);
    db.close();
    return id;
}

IntelliJ Amiya · Accepted Answer · 2018-08-26 06:19:34Z

0

Try by this one :

db.update("yourtable", cvalue, "Profile_Name_for_weekly="+"'"+profilename+"'", null);

edited Aug 26, 2018 at 6:19

IntelliJ Amiya

75.8k15 gold badges170 silver badges199 bronze badges

answered Feb 26, 2014 at 6:38

ritesh4326

6277 silver badges9 bronze badges

Collectives™ on Stack Overflow

Sqlite database updating a row android

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related