Did this help?
----------------------------------------------------------------------
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 2:38 PM, Justin Anderson <janderson....@gmail.com>wrote:
> Also, I use different methods in my while loop:
>
> Cursor dbCursor;
> ...
> dbCursor.moveToFirst();
> while (!dbCursor.isAfterLast())
> {
> //do stuff
> dbCursor.moveToNext();
>
> }
>
>
> ----------------------------------------------------------------------
> 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 2:07 PM, Mikey <frak....@gmail.com> wrote:
>
>> Mostly desperation - I will give your idea a try though - thanks!
>>
>> Mikey
>>
>> On 16 Jun 2010, at 21:04, Justin Anderson wrote:
>>
>> 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
>>
>>
>> --
>> 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
