Hi,

Also, Have you tried a DO WHILE...ENDDO LOOP with a SKIP instead of the SCAN...END loop?

HTH,
Arriyel

>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.