The Cursor won't get filled until you try to retrieve the first row. So if you are stopping the program on the rawQuery, you won't see anything.
On Apr 21, 9:03 am, David Williams <[email protected]> wrote: > Tried that but it didn't make any difference. > > This is weird and I can't work out why the query is not returning any rows. > Is there something else in the debugger I need to be looking at? As > mentioned before, when I copy the DB down to my computer I can see that > there are records there created when my app is first launched. > > Does the NO_COUNT = -1 (for the cursor) mean that no rows were returned? > ------------------------------------------------------------------------ > > David Williams > Check out our WebOS mobile phone app for the Palm Pre and Pixi: > <http://www.dtw-consulting.com/GolfCaddie> Golf Caddie > <http://www.dtw-consulting.com/GolfCaddie> | Golf Caddie Forum > <http://www.dtw-consulting.com/GolfCaddie/forum> | Golf Caddie FAQ > <http://www.dtw-consulting.com/GolfCaddie/faq.html> by DTW-Consulting, Inc. > > On 4/19/2011 10:20 PM, lbendlin wrote: > > > > > Would you be willing to try a raw query? > > > Cursor c = db.rawQuery("SELECT * FROM players", null); > > if (c != null) { > > if (c.moveToFirst()) { > > do { > > int id = c.getInt(0); > > > // other fields etc > > > } while (c.moveToNext()); > > } > > c.close(); > > } > > > Might be easier to debug. > > -- > > You received this message because you are subscribed to the Google > > Groups "Android Developers" group. > > To post to this group, send email to [email protected] > > To unsubscribe from this group, send email to > > [email protected] > > For more options, visit this group at > >http://groups.google.com/group/android-developers?hl=en- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
