>Were you still getting the error before you changed your ALLTRIM(UPPER()) indices?
We haven't changed all of them in our main tables. I think I was still getting the error after I've changed stage tables indexes.
I ran three tests yesterday for big loads. I then ran the original version of the program but didn't wait for its finishing. And today when I came in I saw the messagebox (I put a time spent in messagebox), but didn't see the result and it was gone. Then I tried another test with the original program and got the error right away.
If it's not broken, fix it until it is.
My Blog