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