- Forum posts: 3
Apr 15, 2017, 5:51:07 PM via Website
Apr 15, 2017 5:51:07 PM via Website
A short summary of the app is that it is a quiz game. The question and answers are stored in a database. When a randomly chosen category is shown the subsequent table is chosen with the questions. I have 5 tables that I need to create but only have created three. I get an error on the other two.
Here is the error:
android.database.sqlite.SQLiteException: near "when": syntax error (code 1): , while compiling: CREATE TABLE when(_id INTEGER PRIMARY KEY ,when_question TEXT,when_multiple_choiceA TEXT,when_multiple_choiceB TEXT,when_multiple_choiceC TEXT,when_multiple_choiceD TEXT,when_answer TEXT)
Here is the construction string of the tables and the creation of then on the onCreate method:
static final String CREATE_TABLE_WHEN = " CREATE TABLE " + TABLE_WHEN + "("
+ Key_ID + " INTEGER PRIMARY KEY ,"
+ Key_WHEN_QUESTION + " TEXT,"
+ Key_WHEN_MULTIPLE_CHOICEA + " TEXT,"
+ Key_WHEN_MULTIPLE_CHOICEB + " TEXT,"
+ Key_WHEN_MULTIPLE_CHOICEC + " TEXT,"
+ Key_WHEN_MULTIPLE_CHOICED + " TEXT,"
+ Key_WHEN_ANSWER + " TEXT)";
private static final String CREATE_TABLEWHERE = "CREATE TABLE " + TABLE_WHERE + " ("
+ Key_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
+ Key_WHERE_QUESTION + " TEXT,"
+ Key_WHERE_MULTIPLE_CHOICEA + " TEXT,"
+ Key_WHERE_MULTIPLE_CHOICEB + " TEXT,"
+ Key_WHERE_MULTIPLE_CHOICEC + " TEXT,"
+ Key_WHERE_MULTIPLE_CHOICED + " TEXT,"
+ Key_WHERE_ANSWER + " TEXT" + ")";
public void onCreate(SQLiteDatabase db) {
database = db;
db.execSQL(CREATE_TABLEWHO);
db.execSQL(CREATE_TABLEWHAT);
db.execSQL(CREATE_TABLEWHY);
db.execSQL(CREATE_TABLE_WHEN);
db.execSQL(CREATE_TABLEWHERE);
}