Home » Developer & Programmer » Forms » query data s into the jobs list (oracle 9.2.0.1.0, forms 6i ,windows xp)
query data s into the jobs list [message #330225] Sat, 28 June 2008 01:09 Go to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

hello friends,,


i have 2 items which are retrieved from a single block employees.
1.deptno text item
2.jobs text item but its converted to list box


what i have to achieve is that while entering deptno in the deptno text box ,jobs list show the jobs corresponding to the deptno i entered. i created a trigger n tried with some queries.
which smart trigger i have to create ??
how i have to perform the code??

pls advice me.
thanks in advance.
Re: query data s into the jobs list [message #330229 is a reply to message #330225] Sat, 28 June 2008 01:35 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member


I have a list item name with deptno the values are
10
20
30

now I want to see based on each deptno I want different
jobs like

if I am having a details like
in
deptno 10 -------- clerk
analyst
manager

deptno 20 -------- president
salesman
clerk
in 30 -------- analyst
salesman
If I pressed in deptno list item I want to disply in
job list item those appropriate values
how to do

please help me...........
Re: query data s into the jobs list [message #330254 is a reply to message #330229] Sat, 28 June 2008 05:13 Go to previous messageGo to next message
imran_nu
Messages: 55
Registered: February 2007
Location: Islamabad
Member

Search this forum with Populating List Item and you will easiy find your answer.

However for ease, here is the trigger for creating a record group and populating the list item with it.





declare

r_ix recordgroup;
n number;
query_ok number;


begin
	r_ix:=find_group('q2');
  if not id_null(r_ix) then
  	delete_group('q2');
  end if;	
  r_ix:=create_group_from_query('q2','select ename,ename from emp where deptno=:emp.deptno',FORM_SCOPE,200);
	n:=populate_group(r_ix);
	populate_list('emp.ename','q2');	
	
	
	end;


Try this and let us know if have any other problem
Re: query data s into the jobs list [message #330255 is a reply to message #330229] Sat, 28 June 2008 05:14 Go to previous messageGo to next message
imran_nu
Messages: 55
Registered: February 2007
Location: Islamabad
Member

Search this forum with Populating List Item and you will easiy find your answer.

However for ease, here is the trigger for creating a record group and populating the list item with it.




declare

r_ix recordgroup;
n number;
query_ok number;

begin
	r_ix:=find_group('q2');
  if not id_null(r_ix) then
  	delete_group('q2');
  end if;	
  r_ix:=create_group_from_query('q2','select ename,ename from emp where deptno=:emp.deptno',FORM_SCOPE,200);
	n:=populate_group(r_ix);
	populate_list('emp.ename','q2');	
	
	
	end;


Try this and let us know if have any other problem
Re: query data s into the jobs list [message #330256 is a reply to message #330225] Sat, 28 June 2008 05:29 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

hello imran .
thanks for your reply by the way since i saw the same post while searching.


can i perform this action without using record group ??
Re: query data s into the jobs list [message #337156 is a reply to message #330256] Wed, 30 July 2008 01:22 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: Populate List Item
Next Topic: send email with attachment in from 6i using smtp server
Goto Forum:
  


Current Time: Sun Dec 04 04:39:13 CST 2016

Total time taken to generate the page: 0.06273 seconds