Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing mystery ???
Message
 
To
12/02/1999 19:37:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00185510
Message ID:
00187670
Views:
30
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform