Index problems
John Esak
john at valar.com
Wed Aug 11 08:25:14 PDT 2004
By corrupted data, I meant could ther be a bad value like an 8bit character
in the field. No, I don't really have a way to check this... They look like
little picture frame corners... :-) if that helps, which it doesn't I
know... because you would have to browse the file and atually look at the
data. Too hard, with 20,000 records. Let's see what removing the index
completely does after the rebuild.
John
> -----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 10:53 AM
> To: 'Kenneth Brody'
> Cc: 'FilePro List'
> Subject: RE: Index problems
>
>
> > Tim Fischer wrote:
> > [...]
> > > 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.
> >
> > Can you explain what you mean by "does not come up anywhere
> > near the results"? Where does it come up?
>
> I'm not really sure on this. With well over 20,000 records in
> this table I
> haven't found it yet. I didn't want to say that it's not coming up at all
> simply because I a) doubt that and b) can't prove that.
>
> >
> > > However, if I search for "c&p t" this record is brought right up.
> > [...]
> >
> > As others have pointed out, they have no problems with things
> > like this, and John even tried your exact example. Can you
> > give us more details?
>
> I'm not really sure what kind of details would help. I'm running
> on Solaris
> 9 with FilePro 5.0.13D4.
>
> What other information would be helpful to you?
>
> Thanks!
>
> Tim Fischer
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.736 / Virus Database: 490 - Release Date: 8/9/2004
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
More information about the Filepro-list
mailing list