Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is it something wrong in SP2?
Message
De
23/11/2006 02:53:18
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01171956
Message ID:
01171992
Vues:
7
This is actually a bug which exists in VFP9SP1, but has been fixed in SP2. However, I also see that the documentation is not accurate or complete on this topic. To be able to create an index tag, you need exclusive right to the table. The bug in SP1 is that if you Use a table with no CDX Shared, and then Index on xx Tag yy, you don't get any error, but VFP will change the open status from shared to exclusive without any warning.

So to make it clear, always use a table exclusive when you need to add or delete an index tag.

>Hallo.
>Does anyone has any answer to this.
>
>I have the following code:
>
>Use table1 shared
>Index on field1 tag tfl
>
>This works with VFP9 SP1
>
>BUT... when I try the same code when SP2 has been installed, I get an error for the index line: "File must be opened exclusively."
>
>This code works with SP2:
>
>Use table1 excl
>Index on field1 tag tfl
>
>The only differens in the enviroment is that SP2 has been installed in the second case.
>
>/Kjell
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform