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