Android: SQLite no such table?

Asked Dec 01 '14 at 15:25

Active Dec 01 '14 at 15:42

Viewed 43 times

Hello I am getting a "no such table" error when I want to fill in data in my sqlite db

I am asking myself if the syntax is wrong

  private static final String KEY_ID= "blabla";
    private static final String KEY_VALUE1 = "blabla";
    private static final String KEY_VALUE2 = "blabla";
    private static final String KEY_VALUE3= "blabla";
    private static final String KEY_VALUE4= "blabla";

....

 @Override
public void onCreate(SQLiteDatabase db) {
    String CREATE_TABLE = "CREATE TABLE " + TABLE_EXAMPLETABLE 
            + "("
            + KEY_ID + " INTEGER PRIMARY KEY," 
            + KEY_VALUE1 + " TEXT,"
            + KEY_VALUE2 + " TEXT," 
            + KEY_VALUE3 + " TEXT, "
            + KEY_VALUE4 + " TEXT " 
            + ")";

    db.execSQL(CREATE_TABLE);

}

do you see any mistake?

edited Dec 01 '14 at 15:42

CL.

173,858
17
217
259

asked Dec 01 '14 at 15:25

Steve

1

Too little code. Please add more. – Phantômaxx Dec 01 '14 at 15:28
1

Post a complete stack trace from logcat – Karakuri Dec 01 '14 at 15:29
Post the complete class.... – Badhrinath Canessane Dec 01 '14 at 15:55

Android: SQLite no such table?

0 Answers0