lookup to multi field index

Ken Cole ken.m.cole at gmail.com
Tue Aug 28 16:01:25 PDT 2018


Make sur the 2 variables are defined to match the field size and edit and
concatenate together with an &, no space needed

Ken

On Wed, 29 Aug 2018 at 8:54 am, scooter6--- via Filepro-list <
filepro-list at lists.celestial.com> wrote:

> Having a big of a problem that I haven't encountered before
>
> I have output processing that has 2 variables that I set and then attempt
> to lookup to a file on an index that has 2 fields
>
> za='value1';zb='value2';zc=za<ab
>
> lookup cli file k=zc  i=T -nx
>
> I thought if you had a space between your values it would interpret that as
> the 2 fields you're using in your lookup?
> The two fields in file are (25,*) and (6,*) respectively - the lookup I'm
> doing, the first value za is only 13 characters long (this will vary
> depending on which lookup I'm using, so I made the field length of 25
> anticipating I won't have any values greater than 25) and the 2nd field
> (zb) will always be length of 6
>
> What am I missing here?
>
> thanks
>
> Scott
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://mailman.celestial.com/pipermail/filepro-list/attachments/20180828/a55590c4/attachment.html
> >
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180829/b2079757/attachment.html>


More information about the Filepro-list mailing list