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

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

Nuget pack csproj using nuspec -