Hi all, i have simple relation between songs and albums one to many. I created the album table like this CREATE TABLE albums (id INTEGER PRIMARY KEY ASC, name TEXT, additional TEXT)
My song table is like this StringBuilder sqlQuery = new StringBuilder(); CREATE TABLE songs (id INTEGER PRIMARY KEY ASC, album_fk INTEGER NOT NULL, title TEXT, url TEXT, duration BIGINT NOT NULL) and i have trigger to check when i wan't to delete an album if there are songs in it CREATE TRIGGER trigger_on_delete BEFORE DELETE ON albums FOR EACH ROW BEGIN SELECT RAISE(FAIL,'album has songs cannot be deleted')"); WHERE (SELECT album_fk FROM songs WHERE album_fk = OLD.id) IN NOT NULL;) END and everything is ok and its working fine. But sometimes i got this error Exception: android.database.sqlite.SQLiteConstraintException: error code 19: constraint failed Stack Trace : android.database.sqlite.SQLiteStatement.native_execute(Native Method) android.database.sqlite.SQLiteStatement.execute(SQLiteStatement.java: 66) when i am trying to delete an album. I know what #define SQLITE_CONSTRAINT 19 /* Abort due to constraint violation */ stands for but i can't what constraints can be violated when deleting an album. I can't reproduce this so i can't debug it to find out what's the problem any ideas what could go wrong and cause such error. I've tried playing with string encoding but i think that's not the problem. -- You received this message because you are subscribed to the Google Groups "Android Beginners" group. NEW! Try asking and tagging your question on Stack Overflow at http://stackoverflow.com/questions/tagged/android To unsubscribe from this group, send email to android-beginners+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-beginners?hl=en
