What is The use of moveToFirst () in SQLite Cursors

by

The docs for SQLiteDatabase.query() say that the query methods return:

“A Cursor object, which is positioned before the first entry.”

Calling moveToFirst() does two things: it allows you to test whether the query returned an empty set (by testing the return value) and it moves the cursor to the first result (when the set is not empty). Note that to guard against an empty return set, the code you posted should be testing the return value (which it is not doing).

Unlike the call to moveToFirst(), the test for if(c!=null) is useless; query() will either return a Cursor object or it will throw an exception. It will never return null.

More Related Contents:

  1. SQLite Android Database Cursor window allocation of 2048 kb failed
  2. Retrieve large blob from Android sqlite database
  3. Hindi font not displying correctly in android [closed]
  4. Unable to save and retrieve String data using Sqlite in android
  5. Share SQLite database between 2 android apps?
  6. Location of sqlite database on the device
  7. Android: upgrading DB version and adding new table
  8. How do I view the SQLite database on an Android device? [duplicate]
  9. How to disable the Clear Data button in Application info of Manage application
  10. How to convert image file data in a byte array to a Bitmap?
  11. Store Android SQLite
  12. Android sqlite how to check if a record exists
  13. Does Android Support JDBC
  14. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  15. How to perform an SQLite query within an Android application?
  16. How do I order my SQLITE database in descending order, for an android app?
  17. SQLite Exception no such column when trying to select
  18. android java.lang.IllegalStateException: Couldn’t read row 0, col 0 from CursorWindow
  19. Android SQLite Database, WHY drop table and recreate on upgrade
  20. Android ExpandableListView and SQLite Database
  21. Multiple Table SQLite DB Adapter(s) in Android?
  22. Closing the database in a ContentProvider
  23. How to store sqlite database directly on sdcard
  24. Android SQLite auto increment
  25. Android Device Monitor “data” folder is empty
  26. How to check database on not rooted android device
  27. difference between rawquery and execSQL in android sqlite database
  28. Browse SQLite database from Android Studio [closed]
  29. Get SQLite database from Android app
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment