| multiple records problem! [message #218554] |
Thu, 08 February 2007 11:22  |
oracle06
Messages: 36
Registered: December 2005
|
Member |
|
|
Hello All,
I have two data blocks with master detail relationship.both
blocks are showing multiple records.In master block check boxes are attached for each record.when I select more than one record
in master block than I have to save it,on save button a procedure has been called for genarating a number for each master record where check box is checked.I need whatever numbers are genarating in master records,there generated numbers
should be store for corrosponding each deatil record.
But when I am doing, genarated numbers are not going in deatil block/table.I have set deatil block item property "copy value from",but by doing this it is only showing in one record if the deatil block having more than one record,that was not successful than I have written code for performing this action.
like:--
Declare
a_val varchar2(40);
b_val varchar2(40);
Begin
loop
If :block1.chk1 = 'Y' then
select column1 into b_val fom table1;
end if;
If :block2.column1 = b_val then
a_val:= name_in('block1.col_num1');
copy(a_val,'block1.col_num1');
:block2.col_num1 := a_val;
end if;
end loop;
error:- ORA-01422:Exact fecth returns more than requested number of rows.
100501:non oracle exception.
how to perform this task?
Please guide.
Thank You.
[Updated on: Thu, 08 February 2007 11:25] Report message to a moderator |
|
|
|
| Re: multiple records problem! [message #218834 is a reply to message #218554] |
Sun, 11 February 2007 01:54  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I suggest going back to basics. Create a master block, then a detail block. Create a 'relatations' between the two of them and then use the when-create-record on the detail block to populate the various key fields.
David
Upd: Typo.
[Updated on: Wed, 21 March 2007 00:18] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
