OraFAQ Forum: Forms » Master Detail Form

Home » Developer & Programmer » Forms » Master Detail Form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Master Detail Form [message #148542]

Thu, 24 November 2005 21:35

narendrakumarkm
Messages: 8
Registered: November 2005

Junior Member

I have a master detail form with only 2 text item in master block and 15 records in detail block.

The user enter records for both blocks and saves the record.

I am facing the problem with this.

If the user enters the record in master form and without entering the records in the detail block.If the user saves the record it immediately saves the record although the detail block is empty.

The saving of records should not happen unless the records are entered in the detail block. I have written PRE-INSERT trigger for the master block also.Its not working I am stuck with this.Please If anyone of you worked on this please help me.

Hoping for some solutions

[Updated on: Thu, 24 November 2005 21:36]

Report message to a moderator

Re: Master Detail Form [message #149271 is a reply to message #148542]

Wed, 30 November 2005 22:25

lochan_411
Messages: 16
Registered: November 2005
Location: India

Junior Member

hi on-commit button you can write a code that will check the existance of records in detail block.Even you can use :system.current_block for your trigger.

Report message to a moderator

Re: Master Detail Form [message #149338 is a reply to message #148542]

Thu, 01 December 2005 05:30

Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta

Member

Hi

On Your Master Block you can Write a Trigger ON-INSERT.
In the same trigger check
condition say Some Total Value of some item from Details Block.

IF CONDITION=TRUE THEN
INSERT_RECORD;
END IF;

Same thing you can do for UPDATE_RECORD Also.

Ciao
Atul p

Report message to a moderator

Re: Master Detail Form [message #150056 is a reply to message #148542]

Tue, 06 December 2005 02:01

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Previous Topic:	lov problem
Next Topic:	Problem with JPEG file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:54:14 CDT 2024