Oracle 6i parameter value

20 pts.
Tags:
D2K
D2K 6i
D2K Forms
Oracle 6i
Oracle Forms 6i
HI,
Friends this is Nayeem,
I need a help from your side. i have a report in oracle 6i, the problem is i have three parameter of date like WHERE ((MANT_REQ.REQ_DATE between :DR1 and :DR2)and (MANT_REQ.MANT_REQ_NO=: MAINE_REQUEST)) in this i have list of values for all three parameter my problem is when i m selecting the date between DR1 and DR2 i want to get the  values (LOV) in MAINE_REQUEST only between DR1 and DR2 but here i m getting all the values. so please help me so that i can get only the between that dates values in my LOV.
Here DR1 and DR2 is Date and 
MAINE_REQUEST is number


Software/Hardware used:
D2K oracle
ASKED: May 28, 2011  5:54 AM
UPDATED: May 31, 2011  12:55 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Your LOV record group should include a condition (WHERE CLAUSE) to include only records matching the desired date range.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following