Dummy Variables in browse screens?

Nancy Palmquist nlp at vss3.com
Thu Mar 17 14:17:25 PST 2005


Tim Fischer wrote:

> I'm beating my head against a wall on this one.  Maybe someone can help me?
> 
> First off, I'm running FP 5.0.13 on Solaris 9.
Tim,

In the browse lookup processing - get the associated data using lookup 
and load it into dummy fields that are displayed as part of the browse.

  1 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - 
          If:
        Then: input popup ln(20) "Last Name to find: "
    2 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
          If:
        Then: lookup pat = mospat  k=ln   i=B -nx b="(brw=12 prc=prcstat 
fill=asc
              )[Last              State Capital]*5                *
    3 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
          If:
        Then: 72   *dd"
    4 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
          If:
        Then: end
    5 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
prcstat  If:         'get key from the browse line lookup
        Then: ky(2)=pat(72);dd=""
    6 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
          If:         'lookup state using state code
        Then: lookup stt = states  k=ky   i=A -bx
    7 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
          If: 'get state capital
        Then: dd(15)=stt(3)
    8 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
          If:
        Then: end

This is a sample of the processing that will get data from more than one 
file. Anything you can load into a dummy variable can be added to the 
line, calculations, lookup data, data manipulation, color data, etc. 
The only thing that is not recommended is running calculations.

I have a class scheduled for Monday 3/21 at 3PM EST on browse lookup.  I 
was sitting here working on the class today.  The class is only 1 hour 
and we will be introducing browse lookup and get up to doing a basic 
add/update/delete to another file using browse and popup update.

I have more material than I can fit into one class so there will be a 
Browse2 and maybe even a Browse3 - if people are interested.

See this link for more info: http://www.vss3.com/fpCourses.htm








-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com



More information about the Filepro-list mailing list