I'm not entirely sure, but I noticed my code is a little different than
yours...
Before I loop over the rows in the cursor I call moveToFirst(). So, with
your code that would be c.moveToFirst() right before the while loop. I seem
to remember having some weird issues with the Cursor class but haven't had
any since I've made this change.
Also, why are you setting c to null? There really is no point in doing that
as the garbage collector will get called on you move out of c's scope...
which happens as soon as you leave the try block.
Thanks,
Justin
----------------------------------------------------------------------
There are only 10 types of people in the world...
Those who know binary and those who don't.
----------------------------------------------------------------------
On Wed, Jun 16, 2010 at 12:13 PM, Mikey <frak....@gmail.com> wrote:
> Hi,
>
> I am using a a Sqlite database in my application, but I am having a problem
> with it crashing (seemingly) randomly with the exception in Cursor. (I have
> been unable to recreate the error to give you the exact exception but it is
> something like the cursor being in an invalid state.
>
> I am using the cursor as follows:
>
> public ArrayList<String> fetchPermanent() {
> ArrayList<String> rows = new ArrayList<String>();
> try {
> Cursor c = mDb.query(USERS, new String[] {SCREEN_NAME}, CONSTANT + "='C'",
> null, null, null, null);
> if (c != null && c.getCount() > 0) {
> while (!c.isLast()) {
> c.moveToNext();
> rows.add(c.getString(0));
> }
> c.close();
> c = null;
> }
> }
> catch (Exception e) {
> Log.e("DBERR", e.getMessage());
> }
> return rows;
> }
>
> Does anyone here have any idea what it is I am doing wrong?
>
> Mikey
>
> --
> You received this message because you are subscribed to the Google
> Groups "Android Beginners" group.
>
> NEW! Try asking and tagging your question on Stack Overflow at
> http://stackoverflow.com/questions/tagged/android
>
> To unsubscribe from this group, send email to
> android-beginners+unsubscr...@googlegroups.com<android-beginners%2bunsubscr...@googlegroups.com>
> For more options, visit this group at
> http://groups.google.com/group/android-beginners?hl=en
>
--
You received this message because you are subscribed to the Google
Groups "Android Beginners" group.
NEW! Try asking and tagging your question on Stack Overflow at
http://stackoverflow.com/questions/tagged/android
To unsubscribe from this group, send email to
android-beginners+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-beginners?hl=en
