Aliases and Lookups

[GCC Consulting]

> >
> >Rick Hane wrote:
> >[...]
> > > lookups to the bom file and use an alias for each lookup; 
> however if 
> > > I remember correctly the minute I open another lookup to the same 
> > > file
> >(even
> > > though it has a unique alias) I will move the pointer in the 
> > > previous
> >lookup
> > > to that same file.
> > >
> > > First, is my statement above correct and I loose the pointer?  If 
> > > not
> >then
> > > no problem.  If it is correct, anyone have thoughts on how to do 
> > > this without setting up and complete levelized bom file 
> for each part?
> >
> >While each alias to the same file shares resources, such as the open 
> >file handles and field layout information, they do not share 
> pointer to 
> >the record.  If alias "foo" finds record 123, and then "bar" finds 
> >record 456, alias "foo" continues to point to record 123.

Rick,

Have you considered using array(s) to hold the values you need instead of using
multiple lookups to the file?  Even if you used multiple lookups, holding the
values in an array will let you release the looked up record more quickly
possibly avoiding a record lock situation.

Richard Kreiss
GCC Consulting