I am using oracle form 6i, i want to use drop down list item to select date
I was able to manipulate my codes to get values for the three drop down list items year, month and day
but at when list change trigger on month to populate day , it populated accordingly but at point if I selected other month, it added the days of the new month selected to
the days of already selected month. And delete list_element command failed to provide solution..
Can any one help me out -- <email address removed by moderator so that you won't get spammed for all Eternity>
What i meant is that if i selected 1976 as year and march as month the code will populate days in that month of the year but at same point try to change my month to June or other month
the code failed to populate days with corresponding day of the new month selected alone instead it combined the day of previous month selected and new month together
.Except i exit from the form and run it again
1976 as year and march as month
cursor days(v_last_date in date,vnDays in number) is
select first_day(v_last_date)+rownum-1 sdate from dual
connect by rownum<vnDays+1;
select last_day(to_date(monthITEM||yearITEM,'MonthYYYY')) from dual;
// the month is in the monthITEM
// the year is in the yearITEM
// last_day will have the last day of that month.
//now you have to find the no. of days.
select to_char(last_Date,'dd') into nDays from dual;
for dates in days