Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Try to find out what is the asci() for that "black square" (probably, it is chr(0)).
Then locate for records containing this chr, and delete the entire record, or remove chr from the record.
>We are having a repeating problem here with the data for a VFP application. We are 100% sure it is caused by the server for the network crashing (a novell network). When it happens, records in the VFP tables get corrupted and cause all kinds of strange errors such as not being able to find existing records, not being able to save updates to records, etc.
>
>We can remove the corrupted records and re-enter the data ... not an elegant solution, but it does work. The question I have is: does anyone know a way I can find these records to assure they are all found and removed. I can send you a screen print via email if you'd like to see the record but basically, it looks like every character of data has been replaced with a black square!
>
>I've tried an assortment of "locate" and sorts to no avail. The record exists yet it doesn't, if you know what I mean. Can anyone point me to a solution for finding these records other than manually reading through the table? (They are not huge tables but reading through a couple of hundred k of records is a bit boring!)
>
>
>TIA,
Précédent
Suivant
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