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!>>
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.