Browse lookup problem

[Jeff Harrison]

----- Original Message ----

> From: Richard Kreiss <rkreiss at verizon.net>
> To: Kenneth Brody <kenbrody at spamcop.net>; rkreiss at gccconsulting.net
> Cc: filepro-list at lists.celestial.com
> Sent: Fri, June 3, 2011 3:24:35 PM
> Subject: RE: Browse lookup problem
> 
> 
> 
> > -----Original Message-----
> > From:  filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> >  [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com]  On
> > Behalf Of Kenneth Brody
> > Sent: Friday, June 03, 2011 3:02  PM
> > To: rkreiss at gccconsulting.net
> >  Cc: filepro-list at lists.celestial.com
> >  Subject: Re: Browse lookup problem
> > 
> > On 6/3/2011 12:53 PM,  Richard Kreiss wrote:
> > [...]
> > >>> This works on my system  but fails on their system.
> > 
> > What's different in the file you  have versus the one they have?
> > 
> > >>> 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.
[snip]

Along Ken's line of questioning, do you have ba bb, bc mapped to an array?  Are 
you possibly trying to define them multiple times?  What happens if you run your 
browse without auto processing?  


Also, is it possible that one of your goto(s) that I see after your browse is 
hammering one of these variables ba,bb,bc - or the array if there is one?  Its 
hard to tell without seeing all of your code.

Jeff Harrison
jeffaharrison at yahoo.com
Author of JHExport and JHImport