OraFAQ Forum: Forms » how to retrieve

Home » Developer & Programmer » Forms » how to retrieve

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to retrieve [message #231037]

Fri, 13 April 2007 13:55

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

Report message to a moderator

Re: how to retrieve [message #231123 is a reply to message #231037]

Sat, 14 April 2007 12:41

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

Report message to a moderator

Re: how to retrieve [message #231143 is a reply to message #231037]

Sun, 15 April 2007 01:20

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 ;

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 01:20:57 CST 2025