Re: Form Builder : Insert new records in a Master-Detail relationship within the same table
From: Herbert Fukerider <herbert.fukerider_at_rfn.de>
Date: Thu, 16 May 2002 15:30:56 +0200
Message-ID: <3CE3B490.7FAF3E35_at_rfn.de>
The Black Unicorn wrote:
the problem is, that the 10 record block the item associated to the database column
cannot be updated or inserted alone, as there are other required fields unknown to this block.
As the same item is used in the relation to the detail block, there is no need to update the
master block's item in this case. Thus have a ON-COMMIT-Trigger in your master block,
whith a NULL; statement as your trigger code.
Date: Thu, 16 May 2002 15:30:56 +0200
Message-ID: <3CE3B490.7FAF3E35_at_rfn.de>
The Black Unicorn wrote:
Hello,Hello,I've got another problem. I have two data blocks, one with a list of
usernames (shows 10 records) and one with a one-record display of all the
fields in that same table. They are connected with a simple join.The problem is that I can't Insert new records in the Detail block, when
I try to it gives a FRM-40508: ORACLE ERROR: Unable to INSERT record.
I understand that the problem comes from the relation between the two
blocks, but I have no idea how to solve it.
the problem is, that the 10 record block the item associated to the database column
cannot be updated or inserted alone, as there are other required fields unknown to this block.
As the same item is used in the relation to the detail block, there is no need to update the
master block's item in this case. Thus have a ON-COMMIT-Trigger in your master block,
whith a NULL; statement as your trigger code.
-- _/ _/_/_/ Herbert Fukerider Architekt BDA _/_/_/_/ Landgrabenstr. 52 90443 Nuernberg _/ _/ Email: herbert.fukerider_at_rfn.deReceived on Thu May 16 2002 - 15:30:56 CEST