MyGroceryList

[Keoooo]

Having Problems With the MyGroceryList code.

public void onCreate(SQLiteDatabase db) {
String CREATE_GROCERY_TABLE = "CREATE TABLE " + Constants.TABLE_NAME + "("
+ Constants.KEY_ID + " INTEGER PRIMARY KEY," + Constants.KEY_GROCERY_ITEM + " TEXT,"
+ Constants.KEY_QTY_NUMBER + " TEXT,"
+ Constants.KEY_DATE_NAME + " LONG);";

I have typed it correctly but The SQL code goes orange and causes the app to not work?

    db.execSQL(CREATE_GROCERY_TABLE);

[nyamkamunhjin]

Having Problems With the MyGroceryList code.

public void onCreate(SQLiteDatabase db) {
String CREATE_GROCERY_TABLE = "CREATE TABLE " + Constants.TABLE_NAME + "("

• Constants.KEY_ID + " INTEGER PRIMARY KEY," + Constants.KEY_GROCERY_ITEM + " TEXT,"
• Constants.KEY_QTY_NUMBER + " TEXT,"
• Constants.KEY_DATE_NAME + " LONG);";

I have typed it correctly but The SQL code goes orange and causes the app to not work?

    db.execSQL(CREATE_GROCERY_TABLE);

try changing
public static final int DB_VERSION = 1; -> public static final int DB_VERSION = 2;
in Constants.java