OraFAQ Forum: Forms » Problem on Master Detail Forms

Home » Developer & Programmer » Forms » Problem on Master Detail Forms

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

Problem on Master Detail Forms [message #169667]

Fri, 28 April 2006 02:02

gajanan_kunte
Messages: 5
Registered: April 2006

Junior Member

Hi,

I created one master detail form. On this form i am fetching one master record and displaying appropriate details by using execute_query procedure on detail block. Now if i am inserting or updating a record in detail block for the retrived record then it does'nt works means the record change not reflecting in the table and even at form side it does'nt show any error.....I am unable to trace the error and if anybody is having idea about this then please reply back as soon as possible...

Thanks
Gajanan

Report message to a moderator

Re: Problem on Master Detail Forms [message #169680 is a reply to message #169667]

Fri, 28 April 2006 02:56

ravian
Messages: 8
Registered: December 2005

Junior Member

HI
From Your message it is not clear the problem you have during updating and inserting new records.......

You must Check the Follwing points.

How U enter the record which you get throught execute query?

Are u commiting properly on form.(did u write commit on save button).

Actualy there is no such serious problem in your master detail form.If your problem is not solved by the above points then plz post ur message again with more clear points of problem.

Report message to a moderator

Re: Problem on Master Detail Forms [message #169732 is a reply to message #169680]

Fri, 28 April 2006 08:05

gajanan_kunte
Messages: 5
Registered: April 2006

Junior Member

Hey,

I have created one master detail form and for insertion of new record it is working fine...On save button i did the commit_form and it is storing the records in both the tables i.e. master table as well as detail table.

master table contains mno,tno field. tno is PK.
Detail table contains tno,bno field. tno is FK.

Now suppose if in master table i have records in following manner :
Tno Mno
-----------
1 1
2 2
3 3
In detail table i have records in following manner :
Tno Bno
-------
1 1
1 2
2 1
2 2

Now i am executing my form and enter Mno as 1 and then fetching the value of tno on master block. and as per tno i am executing query in detail block by execute_query statement. It display the appropriate detail records. means if Mno=1 then master tables tno=1 and all details related to tno=1 will be displyed in detail block means two records.

Now i am doing change in the bno field of detail for tno=1.

Now pressing save button to reflect the changes in detail table.
But it is now reflecting and at form level it is not giving any errors....

So, i think by this detail description u can understand the problem..

Thanks
Gajanan

Report message to a moderator

Re: Problem on Master Detail Forms [message #169825 is a reply to message #169667]

Fri, 28 April 2006 22:40

ravian
Messages: 8
Registered: December 2005

Junior Member

HI
There is surely a problem in ur detail
block.........Plz check its relation with master block
at form level....if u still have problem then send me
ur form and script of ur tables.....I will try to
solve ur problem....

Report message to a moderator

Re: Problem on Master Detail Forms [message #169952 is a reply to message #169825]

Mon, 01 May 2006 00:16

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

Senior Member
Account Moderator

Please search this forum for 'master detail'. Try the example of two wizard created blocks, and a wizard created 'relationships'. Then see what is not working.

David

Report message to a moderator