Before asking this query, I have gone through 3 similar links in archive as under. ------------------------ http://news.gmane.org/find-root.php?message_id=%3c054.fe70fb1da2b15c6056833296f57e0261%40ulmcnett.com%3e ------------------------ msg#00244 ------------------------ Ticket #1012 (closed defect: wontfix) ------------------------ DB is MySQL. Chain of Parent:Child:Grandchild:.. is deep In MySQL child tables, referential integrity is 'RESTRICT'. So the DB will give error while deleting a parent record, if child record(s) exist(s).
My idea is to do something like this: * Make use of "beforeDelete()" * In that, iterate through childs, grandchilds, etc. * Use delete() for each bizobj. (should I use deleteAllChildren() here?) bizobj's "REFINTEG" should be what in this case? "CASCADE" or "IGNORE" Pl. suggest if there is any fine-tuning or correction required in my approach. Thanks, Vineet :-) _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
