Dummy Variables in browse screens?

Tim Fischer tim.fischer at trinitytransport.com
Thu Mar 17 14:34:56 PST 2005


Thanks Nancy,

I'm familiar with the method you sampled below, but I was hoping to use just
the default browse processing to keep functionality in tact.

Richard said he had pointed out some code a few days ago that may do what I
need, so I'm hunting that down now.

Tim Fischer

> -----Original Message-----
> From: Nancy Palmquist [mailto:nlp at vss3.com]
> Sent: Thursday, March 17, 2005 5:17 PM
> To: tim.fischer at trinitytransport.com
> Cc: 'Fplist (E-mail)'
> Subject: Re: Dummy Variables in browse screens?
> 
> 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
> 
> 
> 
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.736 / Virus Database: 490 - Release Date: 8/9/2004
> 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.736 / Virus Database: 490 - Release Date: 8/9/2004
 




More information about the Filepro-list mailing list