Hello ALL, I am trying to implement the cascading update functionality, but i hvn't found any good reference to implement the same. My application is having TABLE-1 as master table with 2-3 dependent table and TABLE-2 is a master table for TABLE-3. Now what I want is whenever I mark/change the status of a Record (from active-to-inactive OR vise versa) from TABLE-1 the status of the dependent records from TABLE-2 should also get updated and based on the records of TABLE-2 the status of it's dependent records from TABLE-3 should also get updated.
Can anyone suggest some good ways to implement the same? I was thinking to create a MYSQL stored procedure for this .. will it be a good idea of doing this? NOTE: I can't implement CASCADE UPDATE on mysql table as the mysql's myisam engine does not support this feature. .. Ashish -- View this message in context: http://www.nabble.com/Example-for-cascading-update-tf4381914s16154.html#a12491529 Sent from the Zend Framework mailing list archive at Nabble.com.
