java - SQLIte syntax error but I do not see one -
it working before changed integer not null integer on scores table.
the error "e/sqlitelog﹕ (1) near "(": syntax error"
and statement in question -
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));
update: turns out silly mistake, added '_' in "foreign key"
remove underscore foreign key
Comments
Post a Comment