Re: Cascade Delete Oracle Forms 6.0

<cplatts_at_my-deja.com> wrote in message news:8tpc1e$vli$1_at_nnrp1.deja.com...
> 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

Just a few guesses:

Are the datatypes that are involved all the same (e.g.: char, number, etc.)?

Your relation between the blocks is defined properly?

-Matt Received on Thu Nov 02 2000 - 04:00:09 CET