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.