 Display multi-record control block [message #146396] |
Thu, 10 November 2005 03:26  |
ilhan
Messages: 3
Registered: November 2005
|
Junior Member |
|
|
Hi,
Aim: I entered more than one value in Text item in one block,
display corresponding records in tabular block(another block)
Written Code:
Declare
cursor c1 is select * from fnd_compview where comp_code in(:tab_blk.list);
Begin
-- Control_blk1 is tabular block which contains code,description
columns.
go_block('control_blk1');
clear_block;
For crec in c1 loop
--message(:tab_blk.list);
:control_blk1.code:=crec.comp_code;
:control_blk1.description:=crec.comp_desc;
next_record;
Exit when c1%notfound;
End loop;
end;
IT CAN NOT WORK TO DISPLAY THE RECORD IN MULTI RECORD
[Updated on: Thu, 10 November 2005 06:37] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
