search

tscloud / HiveNotes

Android app for keeping tabs on your bees.
1 stars 0 forks source link

cascade on delete not working #41

Closed tscloud closed 7 years ago

tscloud commented 7 years ago

Need to explicitly turn on foreign key support. Done at the connection level. In onOpen() of MyDBHandler extends SQLiteOpenHelper do:

    if (!db.isReadOnly()) {
        // Enable foreign key constraints
        db.execSQL("PRAGMA foreign_keys=ON;");
    }