jeudi 23 juillet 2015

SQLIte syntax error but I do not see one

It was working before I changed a Integer Not Null to Integer on the scores table.

The error is "E/SQLiteLog﹕ (1) near "(": syntax error"

And the statement in question is -

CREATE TABLE "runs" ("_id" INTEGER PRIMARY KEY, "run_number" INTEGER NOT NULL, "total_time" REAL, "stroop_on" INTEGER NOT NULL, "successful" INTEGER NOT NULL, "successful_run_number" INTEGER NOT NULL, "training_run" INTEGER NOT NULL, "score_id" INTEGER NOT NULL, FOREIGN_KEY (score_id) REFERENCES scores(_id));

Aucun commentaire:

Enregistrer un commentaire