Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to fix a corrupt fpt file NOW!
Message
From
14/04/2000 20:09:22
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00359910
Message ID:
00359935
Views:
10
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform