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 [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
