Browse lookup problem

[Richard Kreiss]

> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
> Sent: Friday, June 03, 2011 12:33 PM
> To: rkreiss at gccconsulting.net
> Cc: filepro-list at lists.celestial.com
> Subject: Re: Browse lookup problem
> 
> On 6/3/2011 12:15 PM, Richard Kreiss wrote:
> > 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
> 
> Pure guess:
> 
> Fields ba, bb, and bc were defined with something not compatible with your
> usage, causing them to not contain what you thought they should.
> 
> What if, just before the lookup statement, you put:
> 
>      mesgbox "ba='" & ba & "'\nbb='" & bb & "'\nbc='" & bc & "'"
> 
Tested this with debug and checked the values of ba, bb & bc.  They we as they should be.  Once I saw that they held the correct values, I recreated the browse and then split it apart using h,I,j and then commented out the original code and test it.  The new code worked.

I then replaced the ba, bb, and bc with  h, I, and J and adjusted the browse command.  This worked fine.

Richard




> --
> Kenneth Brody