Repairing corruption in a memo field/file

[Stanley - stanlyn.com]

Hi Ken,

The PFQUAL export does not work.  I dug up an old email that says it wouldn't.  Take a look...

On Tue, Feb 03, 2009 at 07:56:52PM -0500, Dennis DIller wrote:
> I have a file and I need to fix the blob in it on field 26 with a edit 
> of 16,memo some how it got corrupt. Its in a directory of 
> /appl/eusa1/filepro/deest it does have a quality blobeusa what is the 
> procedure to fix this I went to a blobfix utility that does not work

the stupidly, non-intuitive way to run blobfix on a qualified file is:
blobfix - -m qualifier_name
select the filepro filename from the list of filepro files that comes up.

blobfix is very unrefined - it does not take any other command line arguments that i'm aware of - not even filepro-file-name - the only argument that seems to work is -m -md and -mq do not work, PFQUAL and PFNAME do not work either.

i don't think blobfix was intended for release originally so not much was put into it.  maybe if you complain or bug-report this to fp-tech it would get a higher priority to be made to work like all other fp programs.

--
-Joe Chasan-                           Magnatech Business Systems, Inc.
joe - at - magnatechonline -dot- com   Hicksville, NY - USA
http://www.MagnatechOnline.com         Tel.(516) 931-4444/Fax.(516) 931-1264

Thanks, Stanley




-----Original Message-----
From: Ken Cole [mailto:ken.m.cole at gmail.com] 
Sent: Thursday, March 26, 2015 12:48 AM
To: Stanley - stanlyn.com
Subject: Re: Repairing corruption in a memo field/file

try setting PFQUAL first and see if it runs with that set or most runtimes use -m from memory to set the qualifier.

On Thu, Mar 26, 2015 at 3:44 PM, Stanley - stanlyn.com <stanley at stanlyn.com> wrote:
> Thanks Ken,
>
> OK, I found blobfix in the /appl/fp folder.  When ran, it only asks for the table file name and NO qualifiers.  I ran it from the command line.  I need to run it on a qualifier.  Any suggestions?
>
> Thanks,
> Stanley
>
>
>
>
> -----Original Message-----
> From: Ken Cole [mailto:ken.m.cole at gmail.com]
> Sent: Thursday, March 26, 2015 12:25 AM
> To: Stanley - stanlyn.com
> Subject: Re: Repairing corruption in a memo field/file
>
> Stanley,
>
> Look in the fp folder and sub folders as their used to be a fixmemo or some such application.
>
> Might be worth searching the mail archives as this has been discussed previously.
>
> Regards
>
> Ken
>
> On Thu, Mar 26, 2015 at 3:19 PM, Stanley - stanlyn.com <stanley at stanlyn.com> wrote:
>> Hi,
>>
>>
>>
>> SCO Unix sys5 with filepro dreport 5.0.14d4.
>>
>>
>>
>> Any fix for memo field/file corruption.  I have identified the record 
>> that segvios.  Issuing 212="";write does not help where 212 is the memo field.
>>
>>
>>
>> Thanks,
>>
>> Stanley
>>
>>
>>
>> -------------- next part -------------- An HTML attachment was 
>> scrubbed...
>> URL:
>> <http://mailman.celestial.com/pipermail/filepro-list/attachments/2015
>> 0
>> 326/5185a15c/attachment.html>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes 
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes 
> http://mailman.celestial.com/mailman/listinfo/filepro-list