0

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.

Cytherie
  • 1
  • 4
  • Inspect this line `at org.gandroid.motif.Secondwcscreen$1.onClick(Secondwcscreen.java:218)` – codeMagic Jan 04 '18 at 18:10
  • This is my 218th line and I don't see anything wrong in there I think.myDB.updatePeriodrange(newPeriodrange,id); – Cytherie Jan 04 '18 at 18:16

0 Answers0