browse lookup and -v processing

[John Esak]

> -----Original Message-----
> From: Gary Olman [mailto:garyolman at hvc.rr.com]
> Sent: Sunday, July 30, 2006 5:38 PM
> To: john at valar.com
> Subject: RE: browse lookup and -v processing
>
>
> This is perfect. I keyed it in and low and behold it works great. Thanks
> Gary
>
> -----Original Message-----
> From: John Esak [mailto:john at valar.com]
> Sent: Sunday, July 30, 2006 4:36 PM
> To: Gary Olman
> Cc: Fplist (E-mail)
> Subject: RE: browse lookup and -v processing
>
> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.com]On
>  Behalf Of
> Gary Olman
> Sent: Sunday, July 30, 2006 3:04 PM
> To: Fplist
> Subject: browse lookup and -v processing
>
>
> So I can't believe it but have never used a browse lookup in output
> processing or for that matter in a -v processing. So now I learn it is not
> available in output processing. So what is the approach to get a list you
> can select from? I am using W XP and FP 5.0 Thanks Gary
> <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
>
>
> Gary,
>
> One of the CD's I just sent out to you, has a really good step by
> step movie
> on this topic, maybe two  or three. (I think the Inermediate CD)
> But, here
> in a nutshell is how to populate and put up a listbox, getting
> values out of
> a lookup file. In this type of construction, you should *know* that you
> won't ever be getting more values for the list than the size of the
> dimensioned array. In this example 50. To be safe, if you're not sure how
> big the list is going to be... dimension the arry to 1000 or
> something huge.
> :-)
>
>     1  Then: dim list[50]
>     2  Then: i(2,.0)=""
>          If:
>     3  Then: lookup types=yourfilename k=("") i=A -ng mortyps
> If: not types
>     4  Then: goto do_list
>     5  Then: i=i+"1"
>          If: 'assumes 4 is the type field, i.e., CA, CK, MC, etc
>     6  Then: list[i]=types(4)
>          If: i le "49"
>     7  Then: getnext types;  goto mortyps do_list  If: 'do_list
>     8  Then:
>     9  Then: h(2,.0)=listbox(list,"1",i)
>    10  Then: xx=list[h]
>    11  ...
>
>
>
>
> What you do with the value in xx is up to you.
>
>
> --
> John Esak
> (570) 384-2444
>
> Author of:
> The filePro Survivor Series
> Complete Video Training For filePro On CD See samples at: www.valar.com

Hey great,

I've posted this reply to the list. I wanted you to get the code quickly, so
I double posted it to your From address as well as the list. I might as well
get the benefit of a success story noted publicly. My need for good press is
unending. :-)

John