How to use bind parameters in Report Parameter list trigger [message #89725] |
Fri, 09 July 2004 23:10 |
Rambabu.N
Messages: 3 Registered: July 2004
|
Junior Member |
|
|
Hi,
I want the clarification for the following.
In Reports6i parameter form , i have 2 paramtes
1. deptno - list box.
2.empno - list box.
To populate values dynamically, i have written the code in deptno listbox as
select deptno from dept
now , i wanted to populate the empno's in the empno listbox based upon the above selected deptno.
it is not accepting the following query
select empno from emp where deptno=:deptno;
can't we use Bind parameters in the report parameter list triggers.If so , how please help me to solve the above issue.
Thanking you.
Regards,
Rams.
|
|
|