>>>>>>>>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
>
>Strange. When I first wrote to do it init event I was expecting it this way too. After your reply I created a form with both base tables and the view (each in another grid) and added a button with requery(), select and set order to "in view".
>- First indexing complained about indexing with table buffering so I temporarily turned it off indexed and set buffering on.
>- Even without changing data clicking button raised an error saying "index tag is not found" (alias, name etc was right)
>- It was one of the indexes built in init for the view.
>Maybe missed something will try again.

I hope you're not spending too much time on this for me, because I'm pretty sure I'm not going to do it this way.
I'm curious also, so will play around with it.

BTW, when I did it, I did it from the command window, not a form. I'm going to try a form, when I get done here.

Bill