Hi Arriyel

Yes I have tried DO WHILE it works fine just like SCAN FOR, this is just a matter of honour, if I have coded right then why does it not execute right ;-)

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