Home » Developer & Programmer » Reports & Discoverer » parameter in lov of another parameter
parameter in lov of another parameter [message #90311] Thu, 27 January 2005 09:20 Go to next message
Satya
Messages: 36
Registered: January 2001
Member
I want to use a parameter in lov of another parameter
How do i go about it. It looks like this

param1:

select columns from table where
column=:param2

It throws an error saying that bind variable not allowed.

Report message to a moderator

Re: parameter in lov of another parameter [message #90320 is a reply to message #90311] Fri, 28 January 2005 06:07 Go to previous message
ÇÊ
Messages: 15
Registered: September 2002
Junior Member
You didn't say where you were doing this.

I did a simple test:

Open forms.

Create recordgroup:
RG_NAME
SELECT first_name
FROM s_emp
WHERE
(emp_id = :p_emp_id);

Create lov based on record group

Create non base table and add:
p_emp_id
Name

Tie Lov to Name

Run form.

This worked for me....

Report message to a moderator

Previous Topic: Counting records on a report.
Next Topic: Reports:Data from 2 databases
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 12 15:28:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.