Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fixing table with CMRepair
Message
 
To
16/11/2023 06:06:28
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
01687246
Message ID:
01687264
Views:
29
>>>I have a table from a client that's giving error 41. When I scan through and try to read the memo fields, it throws some errors.
>>>
>>>I bought and downloaded CMRepair. When I run the memo test it offers on this table, it turns up a problem that I suspect is the main issue. But I don't see how I get the tool to fix the problem, and the Help isn't helping.
>>>
>>>Anybody been through this and can guide me.
>>>
>>>Tamar
>>>
>>>P.S. Yes, I've been very lucky over the years and never needed to fix memo corruption before.
>>
>>Do not know this tool, I would try it low level - the format is not that tricky. But guide you through might be a problem to me. If the data is not too private I offer to try it over here.
>
>Thanks for the suggestion. I had a months-old copy of the table and ended up writing code that scanned through, and tried to access the memo fields of each record inside TRY-CATCH. If it failed, I blanked the field and then pulled in the data from the old copy. That resolved the errors. I still need to see if I can grab the content for the memos of the newer records (from, say, a hex editor) and push it back in, but pleased that I was able to resolve the errors.
>
>Tamar

All things considered sounds like a big win. Congrats!
________________
_____/ Regards,
____/ al

___________________________________________
www.jcn-associates.com
Visual FoxPro Database Application Development and IT Project Management
Previous
Reply
Map
View

Click here to load this message in the networking platform