I am getting the error shown below and have seen other questions on this but none of the solutions seem to fix my issue.
I create the table within the OnCreate function, I originally included foreign keys but commented them out as I thought that was the issue. I have created other tables using the same format and it has worked. any idea of why this table wont create like the rest?
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("PRAGMA foreign_keys=ON");
db.execSQL("CREATE TABLE IF NOT EXISTS user (username VARCHAR PRIMARY KEY, password VARCHAR, firstName VARCHAR, surname VARCHAR, email VARCHAR)"); //Create table is not there.
db.execSQL("CREATE TABLE IF NOT EXISTS exercise (exerciseID VARCHAR PRIMARY KEY, exerciseName VARCHAR, muscleGroup VARCHAR, equipmentType VARCHAR)");
db.execSQL("CREATE TABLE IF NOT EXISTS workout (exerciseNameID VARCHAR,userID VARCHAR, date VARCHAR PRIMARY KEY, repRange INTEGER, weightKG INTEGER)");
// db.execSQL("create table " + TABLE_WORKOUT + " (COL_userID VARCHAR, COL_exerciseIDFK VARCHAR,COL_date date,COL_repRange INTEGER,COL_weightKG INTEGER)");
// FOREIGN KEY (COL_exerciseIDFK) REFERENCES " +TABLE_EXERCISE+" (exerciseID), FOREIGN KEY (COL_userID) REFERENCES " +TABLE_USER+ " (username))"
Method of inserting:
public void addWorkout(String exerciseNameID,String userID, String date, int repRange, int weightKG)
{
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(COL_exerciseIDFK, exerciseNameID);
values.put(COL_userID, userID);
values.put(COL_date, date);
values.put(COL_repRange, repRange);
values.put(COL_weightKG, weightKG);
//inserting rows
db.insert(TABLE_WORKOUT, null, values);
db.close();
}
This method is identical to another which works fine.
Any responses are greatly appreciated.
