Hi Cecil,
Yes, I would suggest a view or a Cursor Adapter. That's lately my favorite.
>This is a situation that was set up before I arrived on the scene in this company; so, in their old data, they used character dates, a real sloppy way to go in my opinion.
>
>What I am using is a Buffered table in the data environment, but I could change this to an updateable and parameterized View and allow the user to set the date range.
>
>>You can index parameterized view.
>
>>Filters and grids simply don't like each other even after some improvements in VFP9. So just don't use SET FILTER command.
>
>>Also if you would have an index on date field and have it as a date (why do you use char field for dates), then you can simply use
>
>>select * from myTable whhere date between date(year(date()),1,1) and date()
>
>>You actually need to set lower and upper limit as variables, not directly in a query as I showed here.
If it's not broken, fix it until it is.
My Blog