thank you for help and code,
i can do that
via index at my filed
and replace field with rec(no)all
but i need flag =1 have numbers from 1 to last record
flag=2 from 1 to last record
..
..
..
thanks
>>hi all,
>>
>>i have table have more 20000 records
>>
>>have fields as flag from 1 to 9,
>>
>>i need to replace all fields have flage= 1 numbers from 1 to the last record have flage= 1 as ex.. 145
>>
>>flage= 2 take numbers from 146 to end flage=2 as last record is 445
>>
>>flage= 3 from 446...etc
>>
>>thanks
>
>local lnNumber
>Use yourtable order flag
>go top
>lnNumber=1
>scan
> replace yourfield with lnNumber
> lnNumber=lnNumber+1
>endsacan