Re: Problems with Delete Cascade in Forms

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 21 Feb 2003 09:11:02 -0800
Message-ID: <3E565DA6.45E72009@exesolutions.com>

Barbol wrote:

> I have Oracle 9i version, and I'm developing with Forms 9i.
>
> I can't delete all the data of a Form from this Master, because it is a
> master-detail-detail relation, with relations are nested, and only records
> in the immediate detail block are deleted.
> Anybody know how I can do deletions to multiple levels of a relation?
>
> Thanks in advanced.
>
> Luis

Modify the trigger to delete the child record or write a stored procedure to do it in the back-end and then refresh the master data block.

Daniel Morgan Received on Fri Feb 21 2003 - 11:11:02 CST