Hi Naomi and Hilmar,
Here is my idea:
I have parent-child cursors and our client would like one table where certain fields from the child cursor should be in the parent cursor. So I took a scan..andscan command. In it, first, I queried the child cursor using a "where" condition with the key field from the parent cursor - I used this because there are 200,000 records in the child table, and I thought it was quicker to collect the "child" records in a separate cursor. Then I went through this cursor collecting the necessary records and put them in the parents cursor.

Tamas

>>Yes, you are right. I really messed up on this one :(
>>
>>>Look closer at the code. SCAN is done on one table and loop and skip on another. ...
>
>I had the exact same problem from the first glance, so I had to look few seconds longer. Still I'm not getting the idea.