Nancy,
Thanks for helping me with this! I see what you mean. It
does kinda make sense. I really could have sworn when I first tried this that the CDX already existed, however - I guess my trial & error was mostly errors :).
Mark
>Hello, Mark.
>
>Thanks very much for the fun. I finally got a chance to run the code. Did you notice that it seems that only the index file that is being used exclusively? IOW, this only *works* if the cdx
does not already exist.
>
>So, the table in the first data session isn't getting reflagged as exclusively used. ISEXCLUSIVE remains .F.
>
>So, this actually makes a lot of sense. To reindex, the .DBF (literally the file on disk) doesn't need to be locked. But of course the CDX disk file does. So in session 1 when you created the first index, you "created" the CDX and it got created with exclusive use.
>
>Does that make sense?
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.