indexing

[Kenneth Brody]

On 11/28/2011 8:44 PM, davidrottkamp at echoes.net wrote:
> Hi
>
> I have an indexing problem
>
>
> Sco unix op system
> dxmaint version
> rclerk version

(Your follow-up said that they are 4.5.08.  And the reason they didn't show 
up here is that you attached them as PNG screenshots within your HTML, and 
not text.)

> index A on file being built on a field called Date 8,mdy/
> when index is being updated or rebuilt it is missing records
> I have another index C same file built on date and employee number
>
> index C finds all the date records not found in in index A
>
> This has happened within the last few months of a system that has been running without this issue for years
>
> Ideas suggestions?
[...]

My guess is that you've run into some indexing bug in your ancient (over 12 
years old) version of filePro.  Perhaps one related to lots of records with 
identical keys, which is why index C "works".

-- 
Kenneth Brody