lundi 17 août 2015

Android - Get results from subquery in cursor of android?

I have a subquery sqlite :

SELECT BookDB.ArticleID,BookDB.Title, subquery.Title FROM BookDB, (SELECT 
MetaDataID,Title  FROM MetaDataDB  order by OrderView) subquery WHERE 
subquery.MetaDataID = BookDB.ArticleID;

This query get me results (in editor sqlite) but I can't see any result in cursor of android.

cursor = sql.rawQuery("SELECT BookDB.ArticleID,BookDB.Title, subquery.Title FROM BookDB, (SELECT 
MetaDataID,Title  FROM MetaDataDB  order by OrderView) subquery WHERE 
subquery.MetaDataID = BookDB.ArticleID;", null);
                    if (cursor != null) {
                        do {
                            cursor.moveToFirst();
                            String C = cursor.getString(cursor.getColumnIndex("BookDB.Title"));
                            Log.i("results",C);
                        } while (cursor.moveToNext());
                    }

Note: How I can get results from this line ?

String C = cursor.getString(cursor.getColumnIndex("BookDB.Title"));

Aucun commentaire:

Enregistrer un commentaire