Update query SQLite gives Null Pointer Exception

Question

I have used db=this.getWritableDatabase(); in the constructor itself, so I havent used a specific open or close function. Should I?

public void changeCabLocation(String to_loc, String cab_id2) {
    // TODO Auto-generated method stub
    ContentValues val=new ContentValues();
    val.put(cab_location, to_loc);
    db.update(TB_cabs, val, cab_id+"="+cab_id2, null);
}

public void changeDriverLocation(String to_loc, String driver_id2) {
    // TODO Auto-generated method stub
    ContentValues val=new ContentValues();
    val.put(driver_location, to_loc);
    db.update(TB_drivers, val, driver_id+"="+driver_id2, null);
}

Please share the logcat, mention the specific line your error occurs, and a [mcve]. — OneCricketeer, Apr 27 '16 at 03:22

score 0 · Answer 1 · answered Apr 27 '16 at 03:18

0

Try the following:

db.update(TB_cabs, val, "cab_id=?", new String[] {cab_id2});

answered Apr 27 '16 at 03:18

Gerard Frijters

348
3
11

How does that fix NPE? – OneCricketeer Apr 27 '16 at 03:21
I'm not sure, that's why I've written try. But to me it seems not very reasonable that cab_id (and driver_id) is holding a column name and yes a column value. Was that a wrong assumption? – Gerard Frijters Apr 27 '16 at 03:40
Without the logcat, we can't be clear what is null. So you could be correct, but also not. – OneCricketeer Apr 27 '16 at 03:41
I agree, for sure. – Gerard Frijters Apr 27 '16 at 03:44

Update query SQLite gives Null Pointer Exception

1 Answers1