Unknown column: I'm trying to get foreign keys but my application is closing

Question

        private static final String CREATE_TABLE_PLOT = "create table "
        + TABLE_PLOT + "(" + ID_COLUMN + " INTEGER PRIMARY KEY AUTOINCREMENT, "
        + GROWER_PLOT_AREA+ " TEXT NOT NULL,"
        + GROWER_IRRIGATION_TYPE + " TEXT NOT NULL,"
        + PLOT_SURVEY_NUM + " TEXT NOT NULL,"
        + VILLAGE + " TEXT NOT NULL,"
        + WATER_DEPTH + " TEXT NOT NULL," 
        + GROWER_PLOT_ID + "INT ," + " FOREIGN KEY (" + GROWER_PLOT_ID + ") REFERENCES "
        + TABLE_MEMBER + " ("+ID_COLUMN +"));";

My application is crashing.
What's the problem with my code?

@VishalPatoliya It actually depends on your SQLite version. Foreign keys have been introduced in version **3.6.19**: https://www.sqlite.org/foreignkeys.html — Phantômaxx, Jul 20 '16 at 11:33

Phantômaxx · Accepted Answer · 2016-08-03T14:12:18.840

0

+ GROWER_PLOT_ID + "INT ," + " FOREIGN KEY (" + GROWER_PLOT_ID + ") REFERENCES "

is causing your error, since FOREIGN is being included in the query field list.
Remove the extra comma after INT.
Also add a space before INT

+ GROWER_PLOT_ID + " INT FOREIGN KEY (" + GROWER_PLOT_ID + ") REFERENCES "

edited Aug 03 '16 at 14:12

answered Jul 20 '16 at 11:29

Phantômaxx

37,901
21
84
115

can any one help me how to insert the data into database by using the key_ value function – Gurura Jbijjaragi Aug 03 '16 at 14:03

Unknown column: I'm trying to get foreign keys but my application is closing

1 Answers1