| Solution from populate POPLIST [message #502154] |
Mon, 04 April 2011 18:18  |
 |
EstebanXRK
Messages: 2
Registered: April 2011
Location: Brazil
|
Junior Member |
|
|
-- Solution populate poplist
----------------------------
-- Name of block: block01
-- Name of poplist item: year
-- Name table: tb_years
-- Create on trigger when-new-form-instance
declare
cursor c_cur is
select y.year
from tb_years y
order by 1 desc;
begin
clear_list('block01.year');
for r in c_cur loop
add_list_element('block01.year',c_cur%rowcount + 1 , r.year,r.year);
end loop;
:block01.year := get_list_element_value('block01.year', 1);
end;
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
