Index problems
Nancy Palmquist
nlp at vss3.com
Wed Aug 11 10:54:29 PDT 2004
Tim Fischer wrote:
>>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
>>
>
>
>
> I know what you mean - I have seen that before. Again, I have 20,000
> records with 499 fields each. There's really no way I can go through each
> of those 9,980,000 fields to check for corruption.
>
> Does anyone have a way to automate checking for this type of issue?
>
> 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
>
Tim,
Why don't you make a browse format that displays the *t1 in one column
and the @rn in another column. Make a heading that tells what is what.
Use the index built on T1) and display the records that you find using
the c&p t key that you say finds something.
It should show you the order and what record is displayed. Then
cut&paste the results of the search for c&p and the search for c&p t
And let us see what is displayed. It might help.
Nancy
--
Nancy Palmquist
Virtual Software Systems
PHONE: (412) 835-9417 Web site: http://www.vss3.com
More information about the Filepro-list
mailing list