Hi Arriyel

Thanks for you response but I cannot remove the DELETE outside the loop as there are changes dependent just before the delete and we have a lot of electricity problems here. Any other thoughts.


>Hi,
>
>I think the DELETE is the one causing the problem.
>
>Try moving the delete outside of the SCAN...ENDSCAN loop and use a DELETE FOR instead (might even be faster this way).
>
>HTH,
>Arriyel
>
>>Hi all
>>
>>I have a function skel like below:
>>
>>

>>FUNCTION myFunc
>>
>>	PARAMETERS myID
>>
>>	SELECT myDBF
>>	SET ORDER TO TAG myField
>>
>>	= SEEK(myID)
>>
>>	SCAN WHILE myDBF.myField = myID
>>		SELECT myOtherDBF
>>		*** myOtherDBF manipulation logic goes here
>>
>>		SELECT myDBF
>>		DELETE
>>	ENDSCAN
>>

>>
>>This fails, what am I doing wrong. Just change the WHILE to FOR, though slower will never fail.