Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table index help
Message
De
20/01/2003 09:54:05
 
 
À
20/01/2003 09:36:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00743453
Message ID:
00743460
Vues:
23
Can you please tell us information like the following:

1) Symptom observed that betrays corrupted indexes.

2) The EXACT TAG expressions for each suspect index (I assume they at structural indexes?)

3) Include for #2 any 'qualifications' (like UNIQUE) and any clauses (FOR ...).

4) Can you tell us what environment the application is running in (network OS, # concurrent users, workstation OS)

Maybe then we have a chance to help you.

good luck

>It seems that 4 of the tables in an application have index damage. The first thing I tried was to reindex and pack the tables. That did not seem to work. I then dropped the indexes from one of the tables and recreated them. That seemed to work up front but it seems that that there is something still wrong so I copied the structure and appended the records to the new table and recreated the indexes. I don't think the index correct yet. Are there any other suggestions you may may?
>
>Thanks in advance!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform