All geek questions in one place

SQLite DatabaseUtils.queryNumEntries does not work on a real device, but works on an emulator

I use the following methods: count lines

long numRows = DatabaseUtils.queryNumEntries(ourDatabase, "fuel_table");

And the entries in column c

  long mileagenum = DatabaseUtils.queryNumEntries(ourDatabase, FUEL_DATABASE_TABLE, KEY_MILEAGE);

Both methods work fine on the emulator, but give errors on a real device ...

Any idea what is going wrong? Thanks.

I get an error log as: -

 java.lang.NoSuchMethodError: android.database.DatabaseUtils.queryNumEntries at com.poojag.fuelcheck.FuelStoredInfo.getAvgMileage(FuelStoredInfo.java:252) at com.poojag.fuelcheck.Prediction.onFocusChange(Prediction.java:199) at android.view.View.onFocusChanged(View.java:2742) at android.widget.TextView.onFocusChanged(TextView.java:6957) at android.view.View.handleFocusGainInternal(View.java:2565) at android.view.View.requestFocus(View.java:3720) at android.view.View.requestFocus(View.java:3671) at android.view.View.requestFocus(View.java:3649) at android.view.View.onTouchEvent(View.java:4445) at android.widget.TextView.onTouchEvent(TextView.java:7130) at android.widget.EditText.onTouchEvent(EditText.java:143) at android.view.View.dispatchTouchEvent(View.java:3885) at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:942) at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:942) at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:942) at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:942) at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:942) at com.android.internal.policy.impl.PhoneWindow$DecorView.superDispatchTouchEvent(PhoneWindow.java:1750) at com.android.internal.policy.impl.PhoneWindow.superDispatchTouchEvent(PhoneWindow.java:1135) at android.app.Activity.dispatchTouchEvent(Activity.java:2096) at com.android.internal.policy.impl.PhoneWindow$DecorView.dispatchTouchEvent(PhoneWindow.java:1734) at android.view.ViewRoot.deliverPointerEvent(ViewRoot.java:2216) at android.view.ViewRoot.handleMessage(ViewRoot.java:1887) at android.os.Handler.dispatchMessage(Handler.java:99) at android.os.Looper.loop(Looper.java:130) at android.app.ActivityThread.main(ActivityThread.java:3687) at java.lang.reflect.Method.invokeNative(Native Method) at java.lang.reflect.Method.invoke(Method.java:507) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:867) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:625) at dalvik.system.NativeStart.main(Native Method)
+4
source share
1 answer

queryNumEntries with a choice was introduced in the API level 11. API level 10 runs on your 2.3.6 device.

You can replace it with the usual query for selecting COUNT(*) , for example:

 long mileagenum = DatabaseUtils.longForQuery(ourDatabase, "SELECT COUNT(*) FROM " + FUEL_DATABASE_TABLE + " WHERE " + KEY_MILEAGE, null);
+3
source

Source: https://habr.com/ru/post/1497236/

More articles:


All Articles