create a cursor with posC, newvalue order posC desc, scan and build newvalue, update tabledata with cursordata.
>I am having the following data in a filed posC N (8,2). The Highest among it is 561 and occurs four times in the entire records. The next higher is 549. I need to have difference of 10 points in each next lower digit. So in place of 549 in need 551. Similarly , next higher is 545 that occurs two times , I need 541 for both 545 and like wise
>
>How it will be done ?
>
>
>23
>23
>179
>293
>389
>536
>23
>230
>338
>446
>561
>23
>222
>338
>446
>561
>23
>149
>23
>68
>23
>23
>183
>223
>341
>381
>386
>431
>465
>471
>501
>545
>551
>23
>195
>243
>375
>460
>539
>23
>195
>243
>375
>460
>539
>23
>149
>23
>68
>23
>23
>293
>388
>512
>543
>549
>23
>292
>386
>532
>23
>532
>23
>23
>162
>223
>341
>381
>386
>431
>465
>471
>501
>545
>551
>23
>168
>241
>375
>460
>539
>23
>171
>241
>375
>460
>539
>23
>168
>241
>375
>460
>539
>
>Regards