Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fix Tables with Stonefiled u other.
Message
From
14/02/2000 16:29:24
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00331716
Message ID:
00331931
Views:
20
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform