Browse lookup problem

Richard Kreiss rkreiss at gccconsulting.net
Fri Jun 3 09:47:38 PDT 2011



> -----Original Message-----
> From: Jeff Harrison [mailto:jeffaharrison at yahoo.com]
> Sent: Friday, June 03, 2011 12:39 PM
> To: rkreiss at gccconsulting.net; filepro-list at lists.celestial.com
> Subject: Re: Browse lookup problem
> 
> ----- Original Message ----
> 
> > From: Richard Kreiss <rkreiss at gccconsulting.net>
> > To: filepro-list at lists.celestial.com
> > Sent: Fri, June 3, 2011 12:15:57 PM
> > Subject: Browse lookup problem
> >
> > I have code that has been working for some time now. Today my client
> called and
> >said all she is getting is .00   .00   .00 in the browse  window.
> >
> >        ◄ If:
> >        Then: SHOW  "\r E \r-Update Expiration Date, \r U \r-Update
> >Card, \r D \r
> > 682   -------   -   -   -   -   -   -   -    -   -   -   -   -   -   -   -
> -
> >        ◄ If:
> >        Then: ba="(brw=10  xkey=xdeu show=pkeep prc=nocard fill=desc,top)"
> > 683  -------    -   -   -   -   -   -   -   -   -    -   -   -   -   -   -   -
> >         ◄ If:
> >        Then: bb="[\b5 Master Code    Tp Last  Four    Expires \a-]"
> > 684  -------   -   -    -   -   -   -   -   -   -   -   -    -   -   -   -   -
> >        ◄ If:
> >         Then: bc="*3         <16     *5  XXXX*18      *6"
> > 685  -------   -    -   -   -   -   -   -   -   -   -    -   -   -   -   -   -
> > dokeyA ◄ If:
> >         Then: lookup card = l_card  k=4    i=B -nxm  b=(ba&bb&bc)
> >
> > This works on my system but fails on their  system.
> >
> > I changed ba,bb, & bc to h,I,j and the browse worked as it  should.
> >
> > Ba,bb, and bc are on used in input processing.  They are not  defined
> >in auto processing and the is no @entsel processing.
> >
> > Can anyone  see why this should suddenly fail?
> >
> > The box that came up was square, had  the three  .00's and no header
> > or XXXX
> >
> 
> I assume the .00's show up vertically - one per record, not horizontally on one
> record?  Here is a case where a picture would be worth something.
> 
> You didn't show what the nocard processing label does - could that be a clue?

The browse had no header.  The .00 show as		.00	.00	.00

One row for each of the 3 records to be displayed.

Nocard insured that only that persons records are displayed and that the code in the record is cc.  Prior to the browse being executed, a lookup occurs using the value "CC"&master_code on index F, which is built on these fields.

Once I replaced the ba... with hij letters the browse worked.

Richard



More information about the Filepro-list mailing list