General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
If you quite sure, they are corrupted, then you can do somethimg like this:
use (table) excl
pack
* or like you did, but in foxpro environment:
use (table)
copy to temptable with cdx
use
* Then rename temptable as needed.
>I've had a few user's experience corupt records within several tables do to a server crash, power outage, etc.
>
>Is there a way to detect/delete corupt records? The records read like bar code but as far as I can tell, I can't query them out (delete-sql). I found I can do an export to excel sheet, clean the table and re-import the data. The bad records don't get exported. However, this seems to take a long time. Anyone have a better method?
>
>Thanks in Advance!
>Daren Hopper
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only