Home » Developer & Programmer » Forms » master-detail-detail problem-saving 1 record every time
master-detail-detail problem-saving 1 record every time [message #80178] Tue, 20 August 2002 03:30 Go to next message
puneet
Messages: 76
Registered: August 2002
Member
Please if u could guide me, I am developing application in developer 2000 and oracle.

I have a requirement that there is a master block with its detail and this detail (acts as master for another detail block in the system) has again a detail below it.

1. Master block - single record

2. detail block for the master above - mutiple record

3. another detail block for the (2) block which acts a master for this block- multiple record.

Problem is
as i input data in master(1) then a single record in (2) detail block then move on to 3 block to input mutiple records here , when i return to 2 block, to enter next record it ask me whether i need to save records,

I want to avoid this save message and commit all the records in all blocks at one time when i press my save button afer completing my task.

please help me out
Re: master-detail-detail problem-saving 1 record every time [message #80188 is a reply to message #80178] Wed, 21 August 2002 03:57 Go to previous messageGo to next message
nik
Messages: 55
Registered: January 2002
Member
hi,
nice explanation to your problem.

If you simply need to suppress this message then you
trap via on-message (or on-error, i always get these mixed up!!) at block level (or form level I like block level as this is more specific to operations being performed in that BLOCK ONLY!)

Here is a quick example:

-------------------------
ON-MESSAGE (Block Level)
-------------------------

declare

msgnum number := message_code;
msgtxt varchar2(80) := message_text;
msgtyp varchar2(3) := message_type;

begin

if msgnum = 40353 then
message('Query cancelled !');
elsif msgnum = 41800 then
message('Function not available !');
elsif msgnum = 40352 then
message('You are at the last record !',no_acknowledge);
elsif msgnum = 40301 then
message('No matching records found !') ;
elsif msgnum = 40350 then
message('No records found !');
elsif msgnum = 40355 then
message (msgtxt||'...............');
elsif msgnum = 42100 then
message (msgtxt);
elsif msgnum = 40400 then
message (msgtxt);
elsif msgnum = 40101 then null;
else
message(msgtyp||'-'||to_char(msgnum)||': '||msgtxt);
end if;

end;

Hope this helps you out. If not tell me why.

arios
nik.
Re: master-detail-detail problem-saving 1 record every time [message #80910 is a reply to message #80178] Fri, 13 December 2002 15:41 Go to previous messageGo to next message
saravanan
Messages: 70
Registered: October 2000
Member
i had the same problem and i got the root cause. when the focus is moved to the second record in the second level block, on-clear-details fires and it tries to clear the third level block data which corresponds to first record of 2nd block. but the data in the third block is not yet saved to database. so, it asks for confirmation to commit before clearing. i did not get the solution yet. this will happen even for a two level relationships, when you display more than one record for the first level master. when you do some modifications/additions in the second level and before saving move to another record to first level, the same thing occurs.
Re: master-detail-detail problem-saving 1 record every time [message #354011 is a reply to message #80178] Thu, 16 October 2008 01:29 Go to previous messageGo to next message
fadhzone
Messages: 61
Registered: April 2008
Member
Hi All...
I also faced the same problem tu..when i use the relation it will prompt me the message.but buy doing this it will retrieve the data from database correctly...
but it's correctly function during entry...
it forced me to write the script for manually retrieve..but until now i still want to use relation..
can someone out there help me...

Thanks..
Re: master-detail-detail problem-saving 1 record every time [message #354406 is a reply to message #80188] Sat, 18 October 2008 09:00 Go to previous messageGo to next message
madhuribondre
Messages: 3
Registered: October 2008
Junior Member
Hi,

In Clear_All_Master_Details procedure following changes are needed

Original code....

Clear_Block(ASK_COMMIT);

Changes needed...

POST; --new line added
--Clear_Block(ASK_COMMIT); --commented existing line


HTH,

Madhuri
Re: master-detail-detail problem-saving 1 record every time [message #354743 is a reply to message #354011] Tue, 21 October 2008 01:29 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: Changing LOV parameters at runtime
Next Topic: how to insert my menus in my forms
Goto Forum:
  


Current Time: Sun Dec 11 04:20:17 CST 2016

Total time taken to generate the page: 0.06277 seconds