>>>>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.
Wrong msg. This is the one: 529811