Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupt table
Message
From
28/09/2006 11:56:43
 
 
To
28/09/2006 11:30:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01157866
Message ID:
01157875
Views:
22
Packing or copying are rarely fix corruption. You need a good file fix tool such as FoxFix.

>OK this is a first for me. I have a table "emwosb" that is corrupt but I can't fix it.
>
>reccount() = 424625
>pack
>reccount() = 424625
>copy all to testdbf
>use testdbf
>reccount() = 424621
>
>In a program I use "emwosb" and then set a filter. Then attempt to "scan". The program just sends the CPU to 50% but does not move forward (to the next statement).
>
>I have:
>select emwosb
>copy all to table
>zap
>append from table
>
>Still the scan fails.
>
>The table is indexed and I have removed the index (cdx) and it still goes nuts on the scan.
>
>I have removed the table from the DBC. Used the table as a free table copied the records to a new table renamed and then added back into the DBC. Same issues.
>
>Anybody have a suggestion on what to do next?
>
>John
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform