I keep on getting a null pointer exception when i am trying to update.I had tried toasting the values and its not null at all. Im stuck in here, any help would be great.
01-05 01:50:20.082 31956-31956/org.gandroid.motif E/AndroidRuntime: FATAL EXCEPTION: main
Process: org.gandroid.motif, PID: 31956
java.lang.NullPointerException
at org.gandroid.motif.Secondwcscreen$1.onClick(Secondwcscreen.java:218)
at android.view.View.performClick(View.java:4463)
at android.view.View$PerformClick.run(View.java:18770)
at android.os.Handler.handleCallback(Handler.java:808)
at android.os.Handler.dispatchMessage(Handler.java:103)
at android.os.Looper.loop(Looper.java:193)
at android.app.ActivityThread.main(ActivityThread.java:5292)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:824)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:640)
at dalvik.system.NativeStart.main(Native Method)
This is the error i get when i tried updating.
Bundle b = getIntent().getExtras();
getLastperiod = b.getString("LP");
Date inputdate = sdf.parse(inputlastperiod);
Date getprevdate = sdf.parse(getLastperiod);
newcal.setTime(getprevdate);
String prevperiod = sdf.format(newcal.getTime());
String newperiod = sdf.format(inputdate);
Date PP = null;
Date NP = null;
Integer daysbetween = 0;
try {
PP = format.parse(prevperiod);
NP = format.parse(newperiod);
} catch (Exception e) {
e.printStackTrace();
}
DateTime valPP = new DateTime(PP);
DateTime valNP = new DateTime(NP);
daysbetween = Days.daysBetween(valPP, valNP).getDays();
String newPeriodrange=daysbetween.toString();
Integer id = 1;
if (newPeriodrange!=null) {
myDB.updatePeriodrange(newPeriodrange,id);
}
This is where my update statement lies.
public void updatePeriodrange(String newcyclerange,int id){
SQLiteDatabase dbase = this.getWritableDatabase();
String query = "UPDATE userinfo SET PERIODRANGE= "+newcyclerange+" WHERE ID='"+id+"'";
dbase.execSQL(query);
}
Then this is my databasehelper class.