Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing mystery ???
Message
 
À
12/02/1999 19:37:35
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00185510
Message ID:
00187670
Vues:
29
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform