Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corrupted memo file
Message
De
22/11/1999 19:00:23
 
 
À
22/11/1999 11:46:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00293951
Message ID:
00294138
Vues:
27
>Any suggestions on a utility for restoring corrupted memo files?
>
>This is a file being converted from Alpha4. Anyone remember that program? It used FoxPro 1/dBASE III compatible files. Y2K brings 'em out of the woodwork. TIA.


Ted when you try to access a file with corrupted memos VFP will offer to fix it for you. JUST SAY NO! I've lost hundreds perhaps thousands of memos that way.

First thing to try is to create a valid empty DBF file and append from the corrupted file.

In one case where this would not work I first created an empty DBF with no memo field. I did the append (leaving behind the memos). Then I changed the structure of the new table to add the memo field. (Empty, of course.) Finally I wrote a loop to access the memo data from the corrupted table record by record and copy it to the new table. This was close to 100% successfull.

Peter Robinson
Peter Robinson ** Rodes Design ** Virginia
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform