Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to find skipped number
Message
De
12/08/2004 05:12:11
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00932576
Message ID:
00932606
Vues:
22

Hi all,
I wish to find out all skipped number in a sequence range of numbers.
For example: number range from 1 to 100, if 16 and 79 is absent, then
16 and 79 are the outcomes. If this can be done by just one or two SQL
statements, that's good function. Is there any built-in function inside
Visual FoxPro? Can you help?
Thanks a lot.


Want you all skipped number or all skipped range ?

Example:
Sequence Domain : 1..10
Sequence : 2,3,6,7

all skipped number : 1,4,5,8,9,10

all skipped range  : 1:1,4:5,8:10
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform