-RO causes an error

[Dennis Malen]

I'm not doing a write from Auto proc.

----- Original Message ----- 
From: "Jeff Harrison" <jeffaharrison at yahoo.com>
To: "Dennis Malen" <dmalen at malen.com>; <filepro-list at lists.celestial.com>
Sent: Friday, June 03, 2005 1:59 PM
Subject: Re: -RO causes an error


> --- Dennis Malen <dmalen at malen.com> wrote:
> 
>> Jeff,
>> 
>> In auto proc I am doing a lookup in order to do a
>> show statement when the 
>> file is viewed.
>> 
>> The error is caused when it hits the lookup
>> statement.
>> 
>> In addition, there was a discussion a number of
>> years ago about the -p and I 
>> have not used it since.
>> 
>> I'm surprised Ken Brody has not responded. He should
>> know the answer.
>> 
>> Dennis
> 
> Well, perhaps it would help if you posted the auto
> table that you are using.
> 
> Joe seems to be reporting that he had a similar issue
> and he was able to work around it by building the
> index on two keys.  Why don't you give that a try?
> 
> Regarding the -p I think you mean that you no longer
> use it when you are doing read-only lookups?  You
> should of course always use the -p on your lookups
> when you expect to do a write.  Also, as I mentioned,
> I personally think it is bad form to do any writes
> from automatic processing.
> 
> Jeff Harrison
> jeffaharrison at yahoo.com
> 
> Author of JHExport and JHImport.  The easiest and
> fastest ways to generate code for filePro exports and
> imports.
> 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> 
> 
>