Home » Developer & Programmer » Reports & Discoverer » How to use bind parameters in Report Parameter list trigger
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.
Previous Topic: Unable to communicate with the Connection Store.
Next Topic: Error in Query
Goto Forum:
  


Current Time: Mon Nov 25 17:11:40 CST 2024