>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