I think I figured it out. I was calling getCount() after the database connection was closed.
On Mar 1, 11:48 am, creativepragmatic <[email protected]> wrote: > Never mind. It works. I am not sure why it works now but I am moving > on. > > On Mar 1, 10:40 am, creativepragmatic <[email protected]> > wrote: > > > > > Hello Everyone, > > > I know the error will probably be painfully obvious to you but using > > cursor.getCount() on the result of the following returns a 0 when > > there are multiple items in the table and trips the error "Invalid > > statement in fillWindow()". > > > public Cursor getListItemsCursor(long _listId) { > > > Cursor cur = db.query(LIST_ITEMS_TABLE, > > new String[] { KEY_ID, KEY_ITEM_NAME, > > KEY_ITEM_QUANTITY}, > > KEY_LIST_ID + "=" + _listId, null, null, > > null, null); > > > return cur; > > } > > > Thank you in advance for any assistance, > > > Orville -- 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
