>>>>>>Hi Nick
>>>>>>
>>>>>>How do I index the view? The only thing I see is the order by during a requery(). I don't like that idea,
>>>>>>because it forces a requery() each time a different column is selected, and that can take too long if there
>>>>>>are MANY records to requery().
>>>>>
>>>>>You can index the view with USE myView and INDEX ON... TO just as any regular DBF.
>>>>
>>>>I don't know why I overlooked that, but will it automatically update the indexes when I Requery() the view,
>>>>or do I have to re-issue the index commands?
>>>>
>>>>Bill
>>>
>>>Yes, the index is still open and updated in this case. You can easily experiment with this a little right from Command vindow. Just open your parameterized view, index it and try REQUERY()
>>
>>Thanks, I was going to get started testing that just as soon as I'm finished here. Nice to know that it'll
>>work before I start.
>>
>>Bill
>I thought it this way too as you know. I tested but it was not the case (disappointed), indexes were gone. Did I miss something ?

When I tested it, I did keep the indexes and they did get updated.
1. open view
2. index it (used a prg to do it)
3. browse base file
4. change data and save it
5. requery view
6. change order to the one changed in base file
7. the view reflected the changed data

Bill