Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corupt records...How do you Automate Detection,Delete
Message
De
18/10/2001 19:20:29
Daren Hopper
Sea-Mountain Insurance Brokers
Lynnwood, Washington, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Corupt records...How do you Automate Detection,Delete
Divers
Thread ID:
00570578
Message ID:
00570578
Vues:
30
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform