Dummy Variables in browse screens?
Brian K. White
brian at aljex.com
Thu Mar 17 12:56:47 PST 2005
----- Original Message -----
From: "Tim Fischer" <tim.fischer at trinitytransport.com>
To: "'Fplist (E-mail)'" <filepro-list at seaslug.org>
Sent: Thursday, March 17, 2005 2:27 PM
Subject: Dummy Variables in browse screens?
> 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.
>
> I'm trying to organize a lot of data to make things cleaner and faster.
> This is a file of trucking companies throughout the US, Canada and Mexico.
> To take into account situations where 1 company has multiple offices, I've
> created a Terminal File and a Corporate Office file. All contacts are
> stored in a "contacts" file and all addresses (3 per terminal) are stored
> in
> an "address" file. This is to make change easy - if I need to change an
> address that is duplicated in several places, I make one change to the
> address file and it's all done. The idea is to not duplicate data to keep
> everything clean.
>
> The problem is, if I need to go into the Corporate Office file, sorted by
> "state". I've figured out how to do that (basically by rclerking into the
> address file and using a lot of dummy variables on screen) but I'm needing
> to put some of the data from the Corporate Office file into the browse
> screen. Is this possible? I'd really prefer not to duplicate data, but
> it
> looks like I'm going to have to...
>
> Tim Fischer
I'm not clear what the actual problem is but I'll make a guess and start to
talk about that and you say if it's the right track before I get too
detailed, or maybe the first hints are all you will need anyways.
Is the problem that you want to display info from more than one file in the
same browse list?
No problem.
You can put dummies in a browse display, and you can even fill those
variables on the fly, same variable with different data for each record, by
using browse peocessing.
browse processing runs once for every record collected into the browse.
I think you have the STN book, (I think you have _my_ STN book actually :)
so that contains as good a description of how to use browse processing as
any.
It might be more efficient to do two passes through the data, one pass,
selecting the same records, but not a browse lookup, to populate some
arrays, then the 2nd pass is the browse that has browse processing that only
copies array elements to the dummies in the browse display, rather than
having the lookup to the other file right in the browse processing. That
should result in fewer lookups being performed and a browse user interface
that isn't slower than usual.
Brian K. White -- brian at aljex.com -- http://www.aljex.com/bkw/
+++++[>+++[>+++++>+++++++<<-]<-]>>+.>.+++++.+++++++.-.[>+<---]>++.
filePro BBx Linux SCO Prosper/FACTS AutoCAD #callahans Satriani
More information about the Filepro-list
mailing list