Databases
StackOverflow2013
Postsdbo
POAndroid: how to sum real values from Sqlite?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAndroid: how to sum real values from Sqlite?
    text
    copied!<p>I've got the following code to get a sum of real values (debt amounts stored in an SQlite DB:</p> <pre><code>public double getsumdebt() { Cursor mCursor = db.rawQuery("SELECT SUM(CurrentAmount) FROM tblDebts", null); if(mCursor.moveToFirst()) { return mCursor.getDouble(0); } return mCursor.getDouble(0); } </code></pre> <p>I am trying to return the sum of all the values in the "CurrentAmount" column and display it in a textview:</p> <pre><code> DbAdapter db2 = new DbAdapter(this); double sum= new Double(db2.getsumdebt()); //sum = db2.getsumdebt(); bar.setText("Progress: "+currencysymbol +current +" / " + currencysymbol + sum); </code></pre> <p>however, when I run the app in the emulator, I get a Force close during launch, with the following in the DDMS log:</p> <blockquote> <p>09-26 19:01:19.098: ERROR/AndroidRuntime(677): FATAL EXCEPTION: main 09-26 19:01:19.098: ERROR/AndroidRuntime(677): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.evanrich.android.debtdestroyer/com.evanrich.android.debtdestroyer.mainActivity}: java.lang.NullPointerException 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2663) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2679) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at android.app.ActivityThread.access$2300(ActivityThread.java:125) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2033) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at android.os.Handler.dispatchMessage(Handler.java:99) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at android.os.Looper.loop(Looper.java:123) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at android.app.ActivityThread.main(ActivityThread.java:4627) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at java.lang.reflect.Method.invokeNative(Native Method) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at java.lang.reflect.Method.invoke(Method.java:521) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at dalvik.system.NativeStart.main(Native Method) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): Caused by: java.lang.NullPointerException 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at com.evanrich.android.debtdestroyer.database.DbAdapter.getsumdebt(DbAdapter.java:106) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at com.evanrich.android.debtdestroyer.mainActivity.onCreate(mainActivity.java:73) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2627) 09-26 19:01:19.098: ERROR/AndroidRuntime(677): ... 11 more</p> </blockquote> <p>It looks like it's not able to sum the real values stored in the DB. Can anyone help me?</p> <p>FYI, this is my table constructor:</p> <pre><code>private static final String DATABASE_CREATE = "CREATE TABLE IF NOT EXISTS tblDebts (_id integer primary key autoincrement, " + "Debt text not null, StartingAmount real, CurrentAmount real, " + "InterestRate real, DueDate integer, MinimumPayment real );"; </code></pre> <p>Thanks.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload