Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fatal Exception Error
Message
De
05/01/2005 06:04:23
 
 
À
05/01/2005 05:42:20
Jon Neale
Bond International Software
Wootton Bassett, Royaume Uni
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 6 SP5
Database:
Visual FoxPro
Divers
Thread ID:
00974310
Message ID:
00974328
Vues:
32
Have you tried a complete rebuild of both the table and the index? I have seen situation where both a table and it's index seems to be ok, and even a pack and/or a reindex did not fix it. To rebuild the table completely, you have to copy the file twice
lcSafety=SET('SAFETY')
SET SAFETY OFF
USE myTable EXCLUSIVE
COPY TO dummy WITH CDX
USE dummy
COPY TO myTable WITH CDX
ERASE dummy.*
IF lcSafety='ON' && I hate the macro &, so I never use it unless absolutely necessary
  SET SAFETY ON
ENDIF
NB! VFP8 and VFP9 have better error checking of your tables/indexes!


>Thanks Tore, i'm happy to listen to any suggestions that can help resolve it.
>
>If it was a hardware\cabling problem why would it only ever effect one table?
>
>I have seen before where backup software or virus software can screw the indexes but because its only happend to one table i dont believe it can be that.
>
>Jon
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform