android.database.sqlite.SQLiteException: near "code":

Question

I am trying to make composite primary in TABLENAME1 key that i want to use in two different tables i.e. TABLENAME5 and TABLENAME6 is this possible? i am getting this annoying SQLiteException please help me with that i am very new to android stuff. Here is the code..

public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE " + TABLE_NAME1 + " (teacher TEXT,course TEXT,att TEXT,PRIMARY KEY(course, att), code TEXT NOT NULL, bunk INTEGER, attend INTEGER, room TEXT)");
        db.execSQL("CREATE TABLE " + TABLE_NAME2 + " (id INTEGER PRIMARY KEY, title TEXT, notes TEXT)");
        db.execSQL("CREATE TABLE " + TABLE_NAME5 + " (course TEXT,bunkdate LONG,FOREIGN KEY(course) REFERENCES " + TABLE_NAME1 + "(course) ON DELETE CASCADE)");
        db.execSQL("CREATE TABLE " + TABLE_NAME6 + " (course TEXT,attdate LONG,FOREIGN KEY(att) REFERENCES " + TABLE_NAME1 + "(att) ON DELETE CASCADE)");
        db.execSQL("CREATE TABLE " + TABLE_NAME3 + " (id INTEGER PRIMARY KEY AUTOINCREMENT,year INTEGER, month INTEGER, day INTEGER, hour INTEGER, minute INTEGER, title TEXT, type TEXT, status INTEGER, snooze INTEGER, shakemode INTEGER, mathsolver INTEGER, sun INTEGER,mon INTEGER,tue INTEGER, wed INTEGER,thu INTEGER, fri INTEGER,sat INTEGER)");
       }

and here is logcat:

08-22 01:51:44.419: E/SQLiteLog(1528): (1) near "code": syntax error
08-22 01:51:44.429: E/AndroidRuntime(1528): FATAL EXCEPTION: main
08-22 01:51:44.429: E/AndroidRuntime(1528): Process: com.smart.scheduler, PID: 1528
08-22 01:51:44.429: E/AndroidRuntime(1528): android.database.sqlite.SQLiteException: near "code": syntax error (code 1): , while compiling: CREATE TABLE campus (teacher TEXT,course TEXT,att TEXT,PRIMARY KEY(course, att), code TEXT NOT NULL, bunk INTEGER, attend INTEGER, room TEXT)

you need to define multiple primary keys at the end of the Create table declaration — kandroidj
– kandroidj, Commented Aug 21, 2015 at 21:15

Sergei Glotov · Accepted Answer · 2015-08-21 21:14:32Z

3

According to documentation, table constraints should be after column definitions, i.e. PRIMARY KEY after all columns.

answered Aug 21, 2015 at 21:14

Sergei Glotov

20.4k11 gold badges87 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Max Pinto · Accepted Answer · 2015-08-21 21:12:52Z

2

try to change

        db.execSQL("CREATE TABLE " + TABLE_NAME1 + " (teacher TEXT,course TEXT,att TEXT,PRIMARY KEY(course, att), code TEXT NOT NULL, bunk INTEGER, attend INTEGER, room TEXT)");

to this:

db.execSQL("CREATE TABLE " + TABLE_NAME1 + " (teacher TEXT,course TEXT,att TEXT, code TEXT NOT NULL, bunk INTEGER, attend INTEGER, room TEXT,PRIMARY KEY(course, att))");

and let me know your logcat if doesnt work.

answered Aug 21, 2015 at 21:12

Max Pinto

1,4834 gold badges16 silver badges29 bronze badges

6 Comments

Ar Khan Over a year ago

i did now it says: android.database.sqlite.SQLiteException: unknown column "att" in foreign key definition (code 1): , while compiling: CREATE TABLE attendance (course TEXT,attdate LONG,FOREIGN KEY(att) REFERENCES campus(att) ON DELETE CASCADE)

Max Pinto Over a year ago

att or attdate?, i think you should check the column names

Max Pinto Over a year ago

CREATE TABLE attendance (course TEXT,attdate LONG,FOREIGN KEY(attdate) REFERENCES campus(att) ON DELETE CASCADE) i think should be there

Ar Khan Over a year ago

"attdate" is a different column in TABLENAME6, and "att" is the one (in TABLENAME1) i am trying to make composite PK along with "course" and use "att" column in TABLENAME6 as foreign key

Max Pinto Over a year ago

yes but the TABLENAME6 field is att, and you want to make constraint with TABLENAME1 column attdate, your column names should be as you define in your table. Take a look some samples here alvinalexander.com/android/sqlite-foreign-keys-example

|

Collectives™ on Stack Overflow

android.database.sqlite.SQLiteException: near "code":

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related