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