Index problems

[John Esak]

> -----Original Message-----
> From: Tim Fischer [mailto:tim.fischer at trinitytransport.com]
> Sent: Wednesday, August 11, 2004 9:07 AM
> To: john at valar.com
> Cc: 'filePro mailing list'
> Subject: RE: Index problems
>
>
> John Esak wrote:
> > Well, I am SO bad at figuring out complex asociated field
> > things... but when I started to try and duplicate your
> > problem, I realized that I didn't understand the design
> > enough to copy it. What do you mean by
> >
> > > I have an index built on an associated field (T1) which is built
> > > around 2 text fields (both are 30,ALLUP).  When searching
> > through this
> > > index, I'm
> >
> > I am assuming there are two fields 30,allup in the associated
> > field group,
> > like:
> >
> >    t1) name      30   allup
> >    t1) name      30   allup
>
>
> This is exactly how it's setup.  Sorry I wasn't more clear.
>
>
> >
> > and you have built the index on t1) for 30 characters, right?
> >
>
>
> Yes, the index is built on 30 characters.
>
>
> > If this is so, when I did it and added two records:
> >
> >
> > record 1)
> >      T1) CHESAPEAKE & POTOMAC TELEPHONE
> >      T1) C&P
> >
> > Record 2)
> >      T1) FRED'S FISH MARKET
> >      T1) FFF
> >
> > and then searched by index for c&p, it came right up in this
> > order (in the IUA browse)
> >
> >
> > CHESAPEAKE & POTOMAC TELEPHONE  C&P
> > CHESAPEAKE & POTOMAC TELEPHONE  C&P
> > FRED'S FISH MARKET              FFF
> > FRED'S FISH MARKET              FFF
> >
> > which is a long-about way of saying I couldn't duplicate your
> > problem. But, I did try. Maybe someone else will have some
> > insight on this.
> >
> > John
>
> This is close, but try this setup:
>
> record 1)
>      T1) C&P TELEPHONE
>      T1)
>
> Record 2)
>      T1) FRED'S FISH MARKET
>      T1) FFF
>
> I think that the problem has something to do with the 2nd field
> being blank.
> This is just a guess, but I can't think of any other reason for this.
>
> Thanks again!
>
> Tim Fischer
>

Okay, I tried that and got the record again... but a little differntly...

      C&P TELEPHONE
      FRED'S FISH MARKET                 FFF
      FRED'S FISH MARKET                 FFF


which, at least, shows that I did retrieve the record in its proer order in
the index... but becuase the 2nd field isn't filled it no longer resides in
the index... I guess that makes sense.  Could there be any corrupted data in
your file? Something in the field that shouldn't be?

Stupid question... are you by any chance building the index just on T) ???
Because if you are, this is wrong. That would be really T0)  and not T1).
Just a thought.

John