>>>It's the same message as if you tried USEing a table without the CDX and SET SAFETY is ON, "Structural CDX file is not found". But with SET SAFETY OFF you don't get the above message if ON ERROR is VFP's default. However if you use ON ERROR DO SOMETHING the ON ERROR is triggered even with SET SAFETY OFF.
>>>
>>
>>There is a bug that has existed since the Fox2.x days. This sounds like the same one. Under Fox2.x, my scheme to rebuild tables was to DELETE the CDX, then INDEX ON . This causes the same error to trigger when I open the table. If I tried this in the command window without an error handler, I got the error, hit ignore, then INDEXed. However while using my error handler, I had to take a different approach: USE the table, error handler fires, ignore the error, USE the table again. In other words, I had to use the table twice. It's a strange one, but that's how I got around it. And as far as I'm concerned, it is a bug.
>
>Craig,
>
>Again it is only a bug if it was not intended to work that way. Microsoft intended it to work the way iot does, therefore no bug. BTW, all you have to do is issue a RETRY when the error number is 1707 and you won't to use twice.

Well, you actually will hit the USE command twice. First one will trigger the error, then the RETRY will run the same line of code, which is a USE, so it is the same thing that I was doing.

Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer