browse lookup and -v processing

[John Esak]

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