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