Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
If you quite sure, they are corrupted, then you can do somethimg like this:
use (table) excl
pack
* or like you did, but in foxpro environment:
use (table)
copy to temptable with cdx
use
* Then rename temptable as needed.
>I've had a few user's experience corupt records within several tables do to a server crash, power outage, etc.
>
>Is there a way to detect/delete corupt records? The records read like bar code but as far as I can tell, I can't query them out (delete-sql). I found I can do an export to excel sheet, clean the table and re-import the data. The bad records don't get exported. However, this seems to take a long time. Anyone have a better method?
>
>Thanks in Advance!
>Daren Hopper
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement