| master-detail-detail problem-saving 1 record every time [message #80178] |
Tue, 20 August 2002 03:30  |
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  |
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 |
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 |
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..
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
