Home » Developer & Programmer » Forms » update in master-detail form & FORMS 10g master-detail (merged)
update in master-detail form & FORMS 10g master-detail (merged) [message #188521] Sat, 19 August 2006 00:40 Go to next message
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.
update in master-detail form [message #188628 is a reply to message #188521] Mon, 21 August 2006 01:39 Go to previous messageGo to next message
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 191 times)
Re: update in master-detail form [message #190062 is a reply to message #188628] Tue, 29 August 2006 03:21 Go to previous messageGo to next message
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
Re: update in master-detail form [message #190065 is a reply to message #190062] Tue, 29 August 2006 03:38 Go to previous messageGo to next message
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
Re: update in master-detail form [message #190068 is a reply to message #190065] Tue, 29 August 2006 03:44 Go to previous messageGo to next message
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 154 times)
Re: update in master-detail form [message #191564 is a reply to message #190068] Thu, 07 September 2006 02:29 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
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:
  


Current Time: Sun Dec 04 16:34:21 CST 2016

Total time taken to generate the page: 0.07190 seconds