I assume by "bad" you mean they have some bogus chars in there. I've cleaned them up by doing a strtran() on the field and replacing the chr(0) or whatever they might be with ''.
JH -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions General Account Sent: Tuesday, September 02, 2008 9:23 AM To: [email protected] Subject: Memo file is missing or invalid for some records (VFP9SP2) I've identified 157 records in a table of about 172000 records where the memo field is bad. The other memo fields are fine, but not for these 157 records. Is there any other option to fixing this other than doing a REPLACE MyMemo with "" in MyTable for these records? (Using a 3rd party tool like Abri-Recover is not an option....besides, Abri just cuts out the cancer anyway...it doesn't salvage those f-ed up values, iirc.) [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@shelbynet.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
