Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I make sure to cover it all?
Message
 
 
À
08/07/2011 16:06:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01517745
Message ID:
01517751
Vues:
57
Select A1.*, B1.* from cur A1 INNER JOIN cur B1 on A1.ID < B1.ID

This should create all possible combinations.

>I have to make sure to cover all combinations
>
>For example I have 3 records in my cursor. I want to make sure that I do the following
>
>Sequence of tests
>
>record 1 then record 2 then record 3
>record 1 then record 3 then record 2
>record 2 then record 3 then record 1
>...
>
>so in total the six combinations
>
>1,2,3
>1,3,2
>2,1,3
>2,3,1
>3,1,2
>3,2,1
>
>There could be more than 4... eventually
>
>How can I make sure to do it programmatically?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform