Re: Cascade Delete Oracle Forms 6.0

From: Artur Gramacki <A.Gramacki_at_iie.pz.zgora.pl>
Date: Sat, 04 Nov 2000 15:51:54 GMT
Message-ID: <3a03dd42.416111867_at_news.amu.edu.pl>


On Wed, 01 Nov 2000 15:15:01 GMT, cplatts_at_my-deja.com wrote:

>I am using two data blocks, one master and one detail. I have the
>cascade delete set for the relation to delete any detail records when I
>delete a master record. Oracle created an on-delete trigger that fires
>when the master is deleted and removes the detail records. The trigger
>does not work if I use it the way it was created, eventhough the names
>and structure are correct. If I hard code a value in the delete then
>it works. It appears that my :data_block.column_name is not passing a
>value to the delete statment. If I replace :data_block.column_name
>with a 'string' then the delete works fine. This tells me that the on-
>delete trigger is firing. I need help to determine why
>the :data_block.column_name does not work. All of the text box
>properties are set to active and delete,update,insert allowed. Any
>idea? Any settings
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

try to experiment with:
SET_RELATION_PROPERTY(rl_id,MASTER_DELETES,.......

Regards,
Artur



Artur Gramacki
Technical University of Zielona Gora, Poland
e-mail  : A.Gramacki_at_iie.pz.zgora.pl
hone    : (+48 68) 3282227 
fax     : (+48 68) 3244733 
Received on Sat Nov 04 2000 - 16:51:54 CET

Original text of this message