Home > IT Answers > Oracle > Oracle 6i parameter value
Mohnay17
20 pts.
 Oracle 6i parameter value
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
RELATED QUESTIONS
Answer Wiki:
Your LOV record group should include a condition (WHERE CLAUSE) to include only records matching the desired date range.
Last Wiki Answer Submitted:  May 30, 2011  3:15 pm  by  carlosdl   63,580 pts.
All Answer Wiki Contributors:  carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _