>>Found a mismatch on I801972COL cRate = 0 laArr[1]= 0.100000000
>>Found a mismatch on I518767COL cRate = 0 laArr[1]= 0.100000000
>
>Are you sure the SQL is pulling the same records? AFAIK, in VFP8 we didn't have the support for SQL reading from the buffers, so maybe your SQL statement reads from the file on disk, while your SUM command refers to current buffers?
There is no buffering involved. For some unknown reason all modifications are done on tables directly. I haven't even tried to raise the question why was it done so and how multi-users conflicts were supposed to be resolved.
But since there is no buffering, in both cases the results should match? If we assume delayed save for the changes on the disk, it still doesn't explain how two wrong records were found, since no new records are added and Inv_No and Salesman fields are not touched.
If it's not broken, fix it until it is.
My Blog