Home » Developer & Programmer » Forms » multiple records problem!
multiple records problem! [message #218554] Thu, 08 February 2007 11:22 Go to next message
Messages: 36
Registered: December 2005
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.

a_val varchar2(40);
b_val varchar2(40);

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');
: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 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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.


Upd: Typo.

[Updated on: Wed, 21 March 2007 00:18]

Report message to a moderator

Previous Topic: average number from one item to many item in detail
Next Topic: How do I read files from a certain directory with forms6i
Goto Forum:

Current Time: Wed Oct 26 01:09:45 CDT 2016

Total time taken to generate the page: 0.10618 seconds