Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fixing table with CMRepair
Message
 
À
16/11/2023 06:06:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Divers
Thread ID:
01687246
Message ID:
01687264
Vues:
30
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform