Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL or Code for making a series Uniform
Message
De
24/08/2013 03:23:59
 
 
À
24/08/2013 03:17:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01581255
Message ID:
01581257
Vues:
51
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform