jeudi 9 juillet 2015

Trouble with SQLite query in android

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