Hi all, currently develop an application and when I catch data from database, the record always incomplete. I am curios whether this is because I use distinct, but when removed distinct, the incomplete result also come too. For the example I query to get all dates using rawQuery:
public Cursor getAllDates(String selectedMonth, String selectedYear){ String WHERE_MONTH_YEAR = "t_month = '"+selectedMonth+"' and t_year='" + selectedYear+"'"; return mDb.rawQuery("select t_date from finance where t_month='"+selectedMonth+"' and t_year = '"+selectedYear+"'", null); } the call method for the example: getAllDates("June", "2010"); when the query execute using command line with query:" select t_date from finance where t_month='June' and t_year='2010'; the result should be: 7 8 but in the emulator I get only 8. Anybody ever got issue like this? This is because of what? Somebody please help me, thanks a lot. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en