-RO causes an error

[Jeff Harrison]

--- 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