Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CLOSE INDEXES close structural indexes!
Message
De
23/12/2007 11:37:44
 
 
À
23/12/2007 11:26:29
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01277227
Message ID:
01277233
Vues:
25
>>>I have table with order set in Data Environment.
>>>
>>>When I put CLOSE INDEXES on that table it closes structural index on that table.
>>>
>>>Why is that happening?
>>>In Help stands that it doesn't close indexes opened with table.
>>>
>>>I have checked with ORDER() function before and after CLOSE INDEXES.
>>>Before ORDER() it returns order but after CLOSE INDEXES it returns empty value.
>>
>>May I ask WHY you use this command? I have NEVER used this command, I didn't even know it existed. I always use structural indexes, and if I don't need a specific order, I simply use SET ORDER TO.
>
>I have BEGIN TRANSACTION command that requires that indexes must be closed before continuing.

As I wrote, I NEVER use IDX, I ALWAYS use cdx. I suggest that you do the same. I see no reason to use idx, since cdx is faster AND supported during transactions. I think you should see this lack of support for IDX as a clear hint!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform