>>Hi Pat.
>>
>>>Can anyone give me the final trick to show the progression of an INDEX command WITHOUT getting the function name of the Progression routine written to the index file.
>>
>>While Mark and Kenneth answered your question directly, I have this comment: are you sure you want to do this? You can expect a tremendous increase in the time it'll take to create the index if you display a progress meter.
>>
>>Doug
>
>Definitely Doug! I know it can increase the indexing time but indexing a 2 million records table is a process that takes already a long time and because I don't show the progression, the user presses the button a second time anyway!
>
>Pat
Pat,
You may get what you want if you open a form that autoplays an avi of your choice before you start your lenghty process. I do this for showing the user some indication that there's a process running while executing sql pass-through calls. I tested with the index, and it keeps running just fine:
Use mytable
Do Form myaviform Name oForm
Index On myfield Tag myindex
oForm.Release
The form uses a regular OLE control with the MS animation activex or whatever is called. The control has autoplay=.F. The init of the form has:
This.myolecontrol.autoplay=.t.
This.myolecontrol.Open('myavi.avi')
This tip was on FoxPro advisor too.HTH