mercredi 4 mai 2016

Sqlite Error: SQL(query) error or missing database

I am facing a problem in retrieving a set of strings:

Error Code : 1 (SQLITE_ERROR)
Caused By : SQL(query) error or missing database.
(no such column: recipe_name (code 1): , while compiling:
SELECT Main_ing_name FROM recipe_ingredients where recipe_name='Grilled Vegetables ')

Code :

public ArrayList<String> GetRecipeMain_Ing(String recipe) {
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursorRecipeMain = db.rawQuery("SELECT " + RECIPE_MAIN_ING+ " FROM " + RECIPE_ING_TABLE_NAME + " where " + RECIPE_NAME+"='"+recipe+"'", null);
    cursorRecipeMain.moveToFirst();
    ArrayList<String> array_list_recipe_Ing = new ArrayList<String>();

    while (cursorRecipeMain.isAfterLast() == false) {
        array_list_recipe_Ing.add(cursorRecipeMain.getString(cursorRecipeMain.getColumnIndex(RECIPE_MAIN_ING)));
        cursorRecipeMain.moveToNext();
    }
    return array_list_recipe_Ing;
}

Aucun commentaire:

Enregistrer un commentaire