Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need to fix a corrupt fpt file NOW!
Message
De
14/04/2000 20:09:22
 
 
À
14/04/2000 18:24:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00359910
Message ID:
00359935
Vues:
11
>Help!
>
>Our "Notes" file ORDERS2.FPT, just went south... how can I fix it quick????
>
>TIA


What ever you do, don't accept VFP's offer to fix the FPT file. It will likely delete much of your data.

What I do most often is simply create a null copy of the table (it good to make these ahead of time) and append from the damaged table.

One time when the append would hang at a certain point, I created a new null table without the notes field and appended to that. Next I added a new notes field (empty, of course). Then I wrote a sequential loop to run through both tables and transfer the data in the notes field from the damaged table to the new table, one record at a time. That worked well.

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

Click here to load this message in the networking platform