See message#1155081

>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