[Solved] Query Syntax confirmation


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