I don't think this is the case. When i try to delete album that contains songs i got java.sql.SQLException: album has songs cannot be deleted at org.sqlite.DB.execute(DB.java:275) at org.sqlite.DB.executeUpdate(DB.java:281) at org.sqlite.PrepStmt.executeUpdate(PrepStmt.java:77)
On Thu, Jul 29, 2010 at 3:16 PM, DanH <danhi...@ieee.org> wrote: > SELECT RAISE(FAIL,'album has songs cannot be deleted')"); > > On Jul 29, 5:43 am, manigault <manig...@gmail.com> wrote: > > 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<android-beginners%2bunsubscr...@googlegroups.com> > For more options, visit this group at > http://groups.google.com/group/android-beginners?hl=en > -- When I raise my flashing sword, and my hand takes hold on judgment, I will take vengeance upon mine enemies, and I will repay those who haze me. Oh, Lord, raise me to Thy right hand and count me among Thy saints. -- 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
