- 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);
}
Recommended editorial content
With your consent, external content is loaded here.
By clicking on the button above, you agree that external content may be displayed to you. Personal data may be transmitted to third-party providers in the process. You can find more information about this in our Privacy Policy.