> Is it possible to write a trigger over a table that changes the same > table. To be more clear, say i have a table A, now can i write a > trigger over A which in turn delete some rows in table A. If its not > possible then what may be alternative solution to achieve this.
This may be a better question for a SQLite support group, as SQLite people should know SQLite fairly well. If it helps, here is the SQLite documentation on CREATE TRIGGER: http://www.sqlite.org/lang_createtrigger.html -- Mark Murphy (a Commons Guy) http://commonsware.com Android App Developer Books: http://commonsware.com/books.html -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en