>In vfp50, I have a five record table with a fld called NUM.
>The values in this field are 1,2,3,4,5...
>The index is set to this field (NUM).
>When I change the NUM value in record five from 5 to 1.1,
>the records are in the index order: example
>1,1.1,2,3,4 ---
>Now I run this code:
> -- code-
>i=1
>do while !eof()
>replace num with i
>ship 1
>i=i+1
>endo
>-- end of code --
>Now, my NUM fileds should read 1,2,3,4,5.
>For some reason the second record is skipped by vfp.
>My NUM fields read 1,2,2,3,4
>Does anybody know why?
You got into trap. If you move along index sequence, you shouldn't change value of the field which is part of index expression, because doing this you make a jump (generally).
Edward Pikman
Independent Consultant