RE: [sqlite] ON_DELETE_CASCADE constraint is not working

2005-06-06 Thread Ajay 

Hello there,
Will you please tell me when SQLite will be supporting FOREIGN KEYS and
ON_DELETE_CASCADE? Where can I get more information about version and what's
new feature?
As well as Can someone guide me about how to write and fire trigger that
could do work of "ON_DELETE_CASCADE"

Regards,
Ajay Sonawane




> 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

>  






__ 
Discover Yahoo! 
Stay in touch with email, IM, photo sharing and more. Check it out! 
http://discover.yahoo.com/stayintouch.html

[sqlite] ON_DELETE_CASCADE constraint is not working

2005-06-06 Thread Ajay 
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.

 

Regards,

Ajay Sonawane