Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fix Tables with Stonefiled u other.
Message
De
14/02/2000 16:29:24
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00331716
Message ID:
00331931
Vues:
19
>I want learn to fix tables in VFP6, l think that my network is crashing my tables, always l get error "NOT A TABLE",I restore the backup of file but I get run prgs programs to update the others tables, then I want fix the tables, I know that is header error but I don't know how I fix. I need soon help please,

Since you already have SDT, fixing the tables is easy. First you need to have a set of meta data from a good copy of the table. If you didn't create a set of meta data before the table was corrupted, backup the corrupted table, then overwrite it with a good copy (for example, from an old backup). Open the SDT Database Explorer and let it create meta data for the table (if this is a free table, create a dummy database container first, then bring up the Database Explorer, click on the Add Table button and choose the free table, then choose "No" when it asks if you want to add the table to the database).

Close the Database Explorer, then overwrite the good copy of the table with the backed up bad copy. Run REPAIR.PRG that comes with SDT to repair the table.

Doug
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform