>SELECT SUM() finds wrong records. I re-built index Com_Inv earlier today by deleting it first.
>>
>>
>>You did not do what I said. Why is that? I said to turn off the indexes. You made no indication that you did that.
>>
>>Rushmore does need indexes, but VFP and VFP-SQL can operate without them.
>>
>>Be scientific. Get the correct results from the DATA. Turn off all indexes. Get rid of anything that may be contributing to the problem. Focus on the data structures. Use data that you can visualize clearly. Using live data that exhibits a problem is much harder to diagnose than a small sample that exhibits the same problem.
>
>This is, in my mind, exactly the root to many of Naomi's problems. I told her to add structural indexes a long time ago, but this was "not possible". My guess is, considering all her problems, that she should "take the costs", shut the system down the necessary minutes, and add the structural indexes. That would remove more or less all her problems in a few minutes. After the structural indexes are created, she can remove the unnecessary clauses which refers to her IDXs from her code, one by one, without any effect on her program.
>
>Now she is so busy adding band aid all over, which takes her focus away from the real cause for her problems.

Tore,

This is a huge applicaton that can not be re-written overnight. Are you suggesting to keep existing indexes and add structural indexes as well? I started working there quite recently so I'm not really in a position to change everything right away. I'm doing it little by little and find discrepancies here and there.