Try it like this:
public List<String> getAllLabels() throws SQLiteException {
List<String> labels = new ArrayList<String>();
// Select All Query
String selectQuery = "select " + FIGOODSDETAIL_FINISHGOODS + " from " + FI_GOODS_DETAIL_TABLE ;
SQLiteDatabase db = this.getReadableDatabase();
try {
Cursor cursor = db.rawQuery(selectQuery, null);
// looping through all rows and adding to list
if (cursor.moveToFirst()) {
do {
labels.add(cursor.getString(1));
} while (cursor.moveToNext());
}
cursor.close();
} catch (RuntimeException exe) {
exe.printStackTrace();
this.closeDatabase(); // What does this do that db.close() does not?
errCode = "Err-DB-06";
LogFileCreator.appendLog(errCode + " : " + exe.getMessage());
throw exe;
} finally {
db.close();
}
// returning lables
return labels;
}
solved Query Syntax confirmation