>>>>>>>>>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
Go keep on the work you should do for now. I can't beat my curiosity. In fact I'm pulling my hair with a rotated text control now.