Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to fix corrupted records?
Message
From
25/01/2001 15:34:12
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00468589
Message ID:
00468744
Views:
12
Brenda,
If the data in a free table is corrupt it will usually look like vertical lines because the font usually cannot display unprintable characters correctly. If you were to look at the tables in the development environment most likely the corrupted records will appear to be deleted. They really are not, so packing will not get rid of them. You have to deselect the deletion mark and then delete them so that pack can permanently remove them.


>My client called about some data show showing on the forms. I look in her free table and about every 100 records there is a corrupted record (data looks like all vertical lines.). The free table is ordered by an index so foxpro knows the true value of the data but it does not work correctly in the programs. What can I do? How do you fix a corrupted table. We take backups, but I have no idea how long the data has been bad.
>
>Thanks
>
>Brenda
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform