>Hi Sergey,
>
>Some more info: I tried it in VFP 7 and it has the same problem. Only the time limit seems to be a little lower (95 seconds). The set on which it goes wrong has about 20500 records in table A. If I delete 500 records of this table the code works fine. The time to complete the query drops below the 110 (95 in vfp 7) seconds because of this delete. I tried the same tests on a slower machine. This machine has the same problem and the same time limits. On this slower machine I have to delete more than half of the records to get the qeury working and again this delete gets the time to complete it below the 110. So it really seems to be a time limit problem and not a number of records problem.
>
Hi Mark,
I never heard about anything like that. Can you create simple scanario that reproduces this problem, zip the files and email them to me?
--sb--