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