mercredi 12 août 2015

getting error while creating android sqlite table. error given: missing date column

getting error in get-information method it throws an error saying missing column name date: could you please tell me what is that I am doing wrong here. Appreciate your help in advance. Thank you

public class UserDbHandler extends SQLiteOpenHelper {
private static final String DATABASE_NAME="MEALINFO.DB";
private static final int DATABASE_VERSION=5;
private static final String CREATE_QUERY="CREATE TABLE "+ UserMeals.UserMealInfo.TABLE_NAME+"(id INTEGER, "+
        UserMeals.UserMealInfo.CAL_IN_TAKE+" TEXT, "+UserMeals.UserMealInfo.DATE+" TEXT, "+ UserMeals.UserMealInfo.MEAL_TYPE+" TEXT );";

public UserDbHandler(Context context){

    super(context,DATABASE_NAME,null,DATABASE_VERSION);
    Log.e("DATABASE OPERATION", "Database created / opened.....");

}



public Cursor getinformation(SQLiteDatabase db){
    Cursor cursor;
    String[] projections={UserMeals.UserMealInfo.CAL_IN_TAKE,UserMeals.UserMealInfo.DATE,UserMeals.UserMealInfo.MEAL_TYPE, };
    cursor= db.query(UserMeals.UserMealInfo.TABLE_NAME, projections, null, null, null, null, null);
    return cursor;
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

}

Aucun commentaire:

Enregistrer un commentaire