Hi,

There's nothing in the posted code that could explain why it fails with SCAN WHILE. The SCAN FOR runs faster if there is no order set on table (SET ORDER TO).

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