query data s into the jobs list [message #330225] |
Sat, 28 June 2008 01:09  |
|
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   |
|
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   |
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   |
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
|
|
|
|
|