browse lookup problem

[Richard Kreiss]

> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at bestweb.net]
> Sent: Wednesday, April 09, 2008 6:20 PM
> To: rkreiss at gccconsulting.net
> Cc: 'Filepro-List at Lists. Celestial. Com'
> Subject: Re: browse lookup problem
> 
> Quoting Richard Kreiss (Wed, 9 Apr 2008 17:43:01 -0400):
> 
> > Have an application where I am doing a browse using an index based
> > on a code and last name.
> >
> > This runs from @entsel while sitting on 1 record.
> >
> > An input get some part of a last name such as just the first letter
> > of the last name.
> >
> > 69  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> -   -
> >        ◄ If: gn = ""
> >        Then: ba="(brw=12 xkey=x pop=event fill=asc,top)"
> >  70  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> -   -
> >        ◄ If: gn ne ""
> >        Then: ba="(brw=12 xkey=x pop=event mlen=4 fill=asc,top)"
> >  71  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> -   -
> >        ◄ If:
> >        Then: bb="[\b5Code         Last Name          First Name
> >        Doct
> >  72  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> -   -
> >        ◄ If:
> >        Then: bc="*16           *1                   *2
> *45"
> > 74     ◄ If: gn ne ""     'use group code display all docs in group
> >        Then: lookup mark = l_patient_market  k=lv   i=U -nx
> b=(BA&BB&BC)
> >
> > The first time through everything is fine.
> [...]
> > Now the problem, if I enter just a letter or a complete last name,
> > the browse hangs for a few seconds and then displays records at the
> > end of the file.  Pressing <enter> causes the correct display of
> > records.
> [...]
> 
> What happened to line 73?
Line 73 is the lookup if gn is empty.

> 
> What's in gn?
Gn(4,.0) holds an number between 2500 and 2599
> 
> What's in lv?
Lv=gn&ln	ln(20,*) last name field which can have from 1 to 20 characters.


> 
> After pressing Enter and coming back around, what's in gn and lv?
Gn still holds the group code (see above)

Lv holds the group # and the value of ln and reentered.

> --

OK, Now for one other anomaly, as my client was actively using the file being looked up to, I built an demand index on the same keys as the auto index on my system.  No matter what value I put in for ln, the display started with the names ending in a.

I tested this on my system using the same index keys and the only change in the code was the index letter from U to index 0.

I would expect a browse to act the same way no matter what  type of index us used as long as the keys are the same.  Am I wrong?


Richard Kreiss
GCC Consulting
rkreiss at gccconsulting.net