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