--- Ajay <[EMAIL PROTECTED]> wrote:
> Hello there, > > I have two tables and used constraint ON_DELETE_CASCADE in one of the table > to delete records from second table if records from first table are deleted > which foreign key points to first table. I'm using SQLiteExplorer to > manipulate tables. But it is not working properly. I found all records of > first table as it is though record of foreign key is deleted from second > table. > > Let me know solution. Unfortunately, foreign keys are not supported yet. You can add triggers to achieve the same functionality, although it is not as conveniant. http://www.sqlite.org/omitted.html > > > Regards, > > Ajay Sonawane > > __________________________________ Discover Yahoo! Stay in touch with email, IM, photo sharing and more. Check it out! http://discover.yahoo.com/stayintouch.html