Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index repair by command
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01570514
Message ID:
01570517
Vues:
50
>Hi
>
>A customer of mine was getting the message:
>
>"Index file itens.cdx, Tag itemx is corrupted. Please rebuild it."
>
>How requested the files and did as before:
>
>Use itens exclusive:
>
>In interactive mode, the screen was as below:
>
>MODIFY STRUCTURE
>
>===================================
>Name Expression
>IDX ID
>ITMEX ITEM
>====================================
>
>I deleted them, pressed OK, and notice that file itens.cdx desappeared from folder.
>
>Then I created them again, and the file itens.cdx appeared in folder.
>
>I would like to know how can I execute it by command ?
>I would like to create buttons to do this to avoid customer sending me the folder.
>
>Also, "Tag itemx is corrupted" means something inside .CDX is out of order, or
>a real corruption in .CDX file itself ?
>
>
>Moises

You will use
USE myTable in 0 EXCLUSIVE  ALIAS WorkTable
SELECT WorkTable
DELETE TAGS ALL

INDEX ON SomeColumn TAG TagName
command.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform