Can a BRW LOOKUP be done on a -v table or out processing

Richard Tartaglia fp at masscollector.com
Thu Oct 13 07:12:08 PDT 2005



--- "Brian K. White" <brian at aljex.com> wrote:

> 
> ----- Original Message ----- 
> From: "Richard Tartaglia" <fp_rich at yahoo.com>
> To: "FP List" <Filepro-list at lists.celestial.com>
> Sent: Thursday, October 13, 2005 8:55 AM
> Subject: Can a BRW LOOKUP be done on a -v table or
> out processing
> 
> 
> >I am trying so select a name from one FP file while
> > printing a report from another file.
> >
> > There are lists of names in each record of one
> file.
> > The names are associated with other data in that
> file.
> > There is a corresponding name file to make sure
> names
> > are all spelled the same in each record.
> >
> > I am trying to print a report based on a name. I
> would
> > have to look-up into the name file and set that
> name
> > in a -v table or output processing. I have tried
> both.
> >
> > I have looked but can't find if BROWSE look-up
> will
> > work in ether the -v table of output.
> >
> > When I run processing, the line with the look-up
> is
> > TRUE but it falls through to the next line. I just
> > need to know if I am trying something I shouldn't
> be
> > or if I have gone completely mad and can't write
> code
> > anymore.
> 
> 
> The lookup itself isn't true or false. You may have
> something on the If: of 
> the lookup line to decide if you want to do the
> lookup or not, but I doubt 
> you have or want that here.
> 
> the very next line needs to have the
> if: not dict
> then: gosub fixname  'name wasn't found in
> dictionary
> if:  ' name was ok or has been fixed up by gosub
> then: return    'assuming we were already in a
> "ckname" gosub
> 
> gosub fixname will have the same lookup but with
> browse enabled
> the first lookup will not have browse, it's only
> purpose is to find an exact 
> match or fail.
 
Brian 

You are right, there is no if statment on the look-up
line. I was just making sure the line itself eas being
exicuted. 

I am using a key field lookup to an index and seting
the key to "A" prior to the look-up. The lookup is set
to get the next higher match.

Richard     


More information about the Filepro-list mailing list