OraFAQ Forum: Forms » update in master-detail form & FORMS 10g master-detail (merged)

Home » Developer & Programmer » Forms » update in master-detail form & FORMS 10g master-detail (merged)

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

update in master-detail form & FORMS 10g master-detail (merged) [message #188521]

Sat, 19 August 2006 00:40

debajyoti_p
Messages: 4
Registered: August 2006
Location: Kolkata

Junior Member

I have a master-detail form. I am able to INSERT in the master and detail table. But modification gives problem. On click on Modify button, I am accepting the PK of header table on LOV one after another, but the block status is showing NEW and thats why it is not able update on click of a SAVE button.

Please tell me how to change the block staus to QUERY, so that I can Update the master/detail table at one go.

Please reply urgently. Thanks in advance.

Report message to a moderator

update in master-detail form [message #188628 is a reply to message #188521]

Mon, 21 August 2006 01:39

debajyoti_p
Messages: 4
Registered: August 2006
Location: Kolkata

Junior Member

I am attaching a master-detail form where updating does not takes on click of a modify button. I guess the WHEN-BUTTON-PRESSED trigger code against MODIFY button is not coorect. Can somebody have a look onto my program and suggest the correct sequence aginst modify trigger. Please reply.

Attachment: MOUSMBS.fmb
(Size: 464.00KB, Downloaded 1102 times)

Report message to a moderator

Re: update in master-detail form [message #190062 is a reply to message #188628]

Tue, 29 August 2006 03:21

bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore

Member

Hi

Without table script and sample data, one cannot proceed.
Can you provide the same?

Bhupinder Singh

Report message to a moderator

Re: update in master-detail form [message #190065 is a reply to message #190062]

Tue, 29 August 2006 03:38

debajyoti_p
Messages: 4
Registered: August 2006
Location: Kolkata

Junior Member

Dear Mr. Singh.

Thanks for taking interest into the problem.

I am attaching the script.sql for creating the master and detail table.

The test case parameter:
Branch_mousmbscom_header table: This are mandatory field
Finyear : 2006-2007
Region : ER
Branch : CAL
Mousmbstype : MOU
ProductGroup : HRC
Serial No : 1
Partyname : ABC LIMITED

Branch_mousmbscom_item table: This are mandatory field
Itemno: 1
Branch : CAL
Partycode : A001
Division : 01
Itemno : 2
Branch : CAL
Partycode : A002
Division : 02
Itemno : 3
Branch : CAL
Partycode : A003
Division : 03
Itemno : 4
Branch : CAL
Partycode : A003
Diviosn :04

Kindest Regards,

D Purkayastha

Report message to a moderator

Re: update in master-detail form [message #190068 is a reply to message #190065]

Tue, 29 August 2006 03:44

debajyoti_p
Messages: 4
Registered: August 2006
Location: Kolkata

Junior Member

forgot to attach the script..
Attaching the script herewith.

Attachment: script.sql
(Size: 3.49KB, Downloaded 997 times)

Report message to a moderator

Re: update in master-detail form [message #191564 is a reply to message #190068]

Thu, 07 September 2006 02:29

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

Senior Member
Account Moderator

Have you solved your problem?

Search this forum for 'master detail' or 'master detail when-create-record' to see how other people have done it.

http://www.orafaq.com/forum/m/175372/67467/#msg_175372

David

Report message to a moderator

Previous Topic:	insert into every record value from lov in Oracle forms
Next Topic:	wizard based facility available in fetching the records from more than one table with Base dataBlock

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:45:06 CDT 2024