Home » Developer & Programmer » Forms » how to retrieve
how to retrieve [message #231037] Fri, 13 April 2007 13:55 Go to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

hi everyone,
actually i am facing a problem and it is to retrieve data on post-text-item trigger. the situation is...........

there is a text item (data base block item),and two list items( also database text items) .
now the situation is that ,i want that when i put any valid data in text item and when i press 'tab' ( for next item) data related to that value(in text item) will be shown in list items.and the thing is also that some data regarding text value is once and some are twice or thrice (so it keeps changing according to text value).

so list should be create,populated and retrieve data corresponding to that text value at run time.
that i am not getting ......
please send a solved module which makes the things easy to understand....

REGARDS
RAJAT
Re: how to retrieve [message #231123 is a reply to message #231037] Sat, 14 April 2007 12:41 Go to previous messageGo to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

please give me solution as soon as possible ,i am in trouble and i want it immediately ,so please send any solved solution of my problem, i am still waiting.............

RAJAT
Re: how to retrieve [message #231143 is a reply to message #231037] Sun, 15 April 2007 01:20 Go to previous message
sameer_am2002
Messages: 129
Registered: September 2002
Senior Member
create 1 recordgroup from which you want to populate list item
with where condition of your input item..e.g

Text Item Deptno -- Input Item
List Item Emp -- List Item

so your recordgroup would be
select ename , to_char(empno)
from emp where deptno = :item1 -- this is your input item

then
in the post text item
declare
rg_id recordgroup := find_group('RECORDGROUP1') ;
listid item := find_item('LIST1') ;
begin
if not id_null(rg_id) then
clear_list(listid) ;
if populate_group(rg_id) = 0 then
populate_list(listid , rg_id) ;
end if ;
end if ;
end ;





Previous Topic: more than one layout
Next Topic: (Custom.pll) Raise FORM-TRIGGER-FAILURE
Goto Forum:
  


Current Time: Thu Dec 08 06:33:17 CST 2016

Total time taken to generate the page: 0.11590 seconds