How To Test If Cursor Is Empty in a SQLiteDatabase Query

by

What about testing the cursor like this, and then doing what you’ve said:

if(cursor!=null && cursor.getCount()>0)

getCount ()

Returns the numbers of rows in the cursor

http://developer.android.com/reference/android/database/Cursor.html#getCount()

More Related Contents:

  1. android.database.CursorWindowAllocationException when moving a Cursor
  2. Is it OK to have one instance of SQLiteOpenHelper shared by all Activities in an Android application?
  3. Can’t add parameter ‘this’
  4. How to use an existing database with an Android application [duplicate]
  5. SQlite Getting nearest locations (with latitude and longitude)
  6. Any good ORM tools for Android development? [closed]
  7. Simple export and import of a SQLite database on Android
  8. Foreign key constraints in Android using SQLite? on Delete cascade
  9. SQLite in Android How to update a specific row
  10. Using Singleton design pattern for SQLiteDatabase
  11. Database not copying from assets
  12. Android search with Fragments
  13. Which Android Data Storage Technique to use?
  14. Get generated id after insert
  15. How to persist permission in android API 19 (KitKat)?
  16. Upgrade SQLite database from one version to another?
  17. Android: Cannot perform this operation because the connection pool has been closed
  18. SQLiteOpenHelper failing to call onCreate?
  19. What is the use of BaseColumns in Android
  20. What is the correct way to do inserts/updates/deletes in Android SQLiteDatabase using a query string?
  21. Android : Table has no column named “variable name” MySql Database error
  22. android.database.sqlite.SQLiteException: no such column
  23. UNIQUE constraint failed: sqlite database : android
  24. Read data from SQLite where column name contains spaces
  25. CollapsingToolbarLayout doesn’t recognize scroll fling
  26. How to print out returned message from HttpResponse?
  27. Can’t Disable Offline Data In Firestore
  28. Android java.lang.NoClassDefFoundError: org.jsoup.Jsoup
  29. How to add rectangles on top of existing rectangle in canvas
  30. C++ ifstream.getline() significantly slower than Java’s BufferedReader.readLine()?

Leave a Comment