i have listView with to viewType. for the first viewType i get data from one SQLite table, and for others - from another table. I am using inner join to join this two tables like this:
static {
sProfileWithHobbiesBuilder = new SQLiteQueryBuilder();
sProfileWithNewsBuilder.setTables(
UsersInfoEntry.TABLE_NAME + " INNER JOIN " +
HobbiesEntry.TABLE_NAME + " ON " +
HobbiesEntry.TABLE_NAME + "." + HobbiesEntry.USER_ID + " = " +
UsersInfoEntry.TABLE_NAME + "." + UsersInfoEntry.USER_ID);
}
all works fine, but... but if the second table is empty, getColumnCounts return 0 and nothing shown... But I need the next result: if the second table is empty, just show info for the first viewType...
will be glad any ideas to fix this question!
Aucun commentaire:
Enregistrer un commentaire