In order to be as safe as you can, any time you're about to create an index on a table, I would make sure you SET EXCL ON first, or have EXCL in the USE command.

Cheers,
Rich

>Thanks for looking into this, guys!
>
>To answer your concerns, the table in use is a free table (TYPE FOX2X) with a structural CDX file already created.
>
>I do *not* use the OF clause.
>
>As to how I get to step#4 - ???? Actually, after experimenting with this over & over, the results vary - it does it only maybe half the time, even with being careful to reset everything between tries - I think this whole think can be racked up to "flakiness".... :)
>
>Mark
>
>>Ah, gee, that's what I get for keepin' my nose to the grindstone! :-)
>>What a freaky thing. Thanks for the info.
>>
>>If that is Mark's case, then I suppose it would make sense that the second cursor would have odd side-effects. In any case, the whole scenario seems, well, shaky, to be honest.
>>
>>>Nancy,
>>>
>>>This may or may not be the answer. If it is, Mark left out something in his list. In a discussion we had about INDEX on a few days ago, we discovered (to my surprise) that if you used INDEX ON Expr TAG Expr OF CdxFile, and named a non-structural CdxFile in which to create the index, you actually did not have to have the table open exclusive!
>>>