Index problems

[John Esak]

> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of Tim
> Fischer
> Sent: Wednesday, August 11, 2004 8:22 AM
> To: 'FilePro List'
> Subject: Index problems
>
>
> I'll start off by saying that this one's a pretty weird one.
>
> 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
> getting some very inconsistent results.
>
> I have a record that looks like this:
>
> 1- T1)Name = "c&p transport"
> 2- T1)DBA Name = ""
>
> When I search for "c&p" this record does not come up anywhere near the
> results.  However, if I search for "c&p t" this record is brought
> right up.
>
> I also have a record that looks like this:
>
> 1- T1)Name = "High and Tight Transport"
> 2- T1)DBA Name = "H&T Transport"
>
> When I search for H&T, everything works fine.
>
> I'm truly stumped on this - has anyone had similar issues with
> indexes built
> on associated fields???
>
> TIA!!
>
> Tim Fischer

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

and you have built the index on t1) for 30 characters, right?

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