>Change the view definition to be
>
>personid >= ?personid1 and personid <= ?personid2
>and
>year >= ?year1 and year <= ?year2
>
>
>To retrieve all the records, make personid1 and year1 smaller than the lowest possible values and personid2 and year2 bigger than the largest possible values.
>
>To retrieve for a specific person/year combination, set personid1 the same as personid2 and year1 the same as year2.
>
>>I have a local view that uses an integer and a year to retreive training records. The integer is the personid and the year is for the training year. Is there a way I can send a parameter that will retrieve all the training records?
>>The SQL where is as follows:
>>WHERE personid = ?vwpersonid;
>>AND yesr(class_date) = ?vwyear
Cool. I'll try this... Thank you Craig.
Thanks in advance or I hope this helps!
[STS]
:>