how to update sqlite db in Android?

Question

I want to update one row based on multiple row value, After run the application getting error like = ( FATAL EXCEPTION: main android.database.sqlite.SQLiteException: near "=": syntax error (code 1): , while compiling: UPDATE Tablename SET sFollowed=?,Code=?,Name=? WHERE Vessel_Name= )

Here is my update method in MyDbhelper class

public boolean update_isFollowed(String strVesselName , String strVesselNotationNumber, String strIsFollowed) {
        SQLiteDatabase db1 = getReadableDatabase();

        ContentValues values=new ContentValues();
        values.put(COL_VesselName,strVesselName );
        values.put(COL_ClassCodeNumber , strVesselNotationNumber);
        values.put(COL_IsFollowedVessels, strIsFollowed);

       int id=db1.update(Table_VesselList,values,COL_ClassCodeNumber + "=" +strVesselNotationNumber +" and "+ COL_VesselName +"="+strVesselName,null);

        return id > 0;
    }

Check that strVesselName is not null.

Sebastian
– Sebastian

2015-08-03 11:51:49 +00:00
Commented Aug 3, 2015 at 11:51 — Sebastian
– Sebastian, Commented Aug 3, 2015 at 11:51

Srikanth K · Accepted Answer · 2015-08-03 12:05:39Z

1

Do something like this

In your activity

private UpdateDataInDB mUpdateDataInDb;
mUpdateDataInDb = new UpdateDataInDB(activity);

// call the update method with updated strings
mUpdateDataInDb.updateCommentDetails(_name, heading, comment);

In Database class

public void updateCommentDetails(String name, String updatedHeading,
        String updatedComment) {
    // TODO Auto-generated method stub
    mDatabase = mDatabase_handler.getReadableDatabase();
    ContentValues args = new ContentValues();
    args.put("Heading", updatedHeading);
    args.put("Comment", updatedComment);
    mDatabase.update("AddCommentTable", args,"Name" + "= ?", new String[]{ name });
    args.clear();
}

answered Aug 3, 2015 at 12:05

Srikanth K

1903 silver badges12 bronze badges

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

Comments

ρяσѕρєя K · Accepted Answer · 2015-08-03 11:55:03Z

0

Use proper where condition string with values as argument. like:

String where = COL_ClassCodeNumber+"=? AND "+COL_VesselName="?";
String[] whereArgs = new String[] {String.valueOf(strVesselNotationNumber),
                                   String.valueOf(strVesselName)};
int id=db1.update(Table_VesselList,values,where,whereArgs);

answered Aug 3, 2015 at 11:55

ρяσѕρєя K

133k54 gold badges203 silver badges216 bronze badges

Collectives™ on Stack Overflow

how to update sqlite db in Android?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related