>>>Why not index it once in the load of the form ? I see no need to delete and recreate the indexes for every requery()
>>
>>Back in '03 i was getting a vfp error with these same INDEX commands for views that would result in...
>>
>>
Table v_viewname has one or more non-structural indexes open. Please close them and retry the Begin Transaction
>>
>>I believe what helped that problem was the addition of code to blow away and re-create the tags before & after a requery.
>
>Chris,
>
>I do this all the time. Index the view once in the load of the form
>
>Why not give it a try ?
Thanks for the reply. Here's a good summary of the problem i was dealing with a few years ago... msg #031587
I'm hessitant to revert back and possibly re-introduce the old problem. Plus its been working for years w/o incident. Its very intermittant, and its just one user.