Help Foreign Key issue

[Iqra Malik]

issue in assigning forign key to a table... it gives me null in foreign key column... plz help me to solve it....

1. @override
2. public void onCreate(SQLiteDatabase db) {
3. db.execSQL("create table " + TABLE_NAME + " (LID INTEGER PRIMARY KEY AUTOINCREMENT,NAME TEXT, AGE INTEGER,GENDER TEXT )");
4. db.execSQL("create table " + TABLE_NAME1 + " (DID INTEGER PRIMARY KEY AUTOINCREMENT,HEIGHT INTEGER,WEIGHT INTEGER,RESULT INTEGER,DISPLAY DATETIME," +
5. "DATA_ID INTEGER,FOREIGN KEY(DATA_ID) REFERENCES login_table(LID))");
6. db.execSQL("create table " + TABLE_NAME2 + " (SID INTEGER PRIMARY KEY AUTOINCREMENT,SCHEDULE DATETIME)");
7. 
   
8. db.execSQL("CREATE TRIGGER fk_data_login " + " AFTER INSERT "+ " ON "+TABLE_NAME1+ " FOR EACH ROW BEGIN"+
9. " SELECT CASE WHEN ((SELECT "+COL_1+" FROM "+TABLE_NAME+" WHERE "+COL_1+"=new."+COLUMN_6+" ) IS NULL)"+ " THEN RAISE (ABORT,'Foreign Key Violation') END;"+ " END;");
10. }

 

[Sudhanshu kumar]

I feel like your at wrong place:?