Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making a 'grid' table
Message
 
 
À
29/05/1998 10:32:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00102892
Message ID:
00103101
Vues:
19
>Cross-tabulation will allow you to make following transition:
>Source Table structure:
>1. ZoneName1
>2. ZoneName2
>3. Fare
>i.e. you have three field records:
>z1 z2 35.80
>z2 z1 35.80
>z1 z3 67.00
>z3 z1 67.00
>z2 z3 15.00
>z3 z2 15.00
>etc.
>
>Output Table structure, if you use ZoneName1 as rowfield and ZoneName2 as columnfield:
>1. ZoneName1
>2. z1
>3. z2
>4. z3
>.... depending how many distinct ZoneName2 you have in source table
>i.e. you have cross-field filled by fares
>Zone Name Z1 Z2 Z3
>Z1 0 35.80 67.00
>Z2 35.80 0 15.00
>Z3 67.00 15.00 0
>
>Is it what are looking for?

Ok... I guess I can fill in the data with 0.00. See, I don't know what the fares are until the user fills in the grid. But I could put 0's in to start.

To get the input table I can join the zone table with itself, as someone else (sorry, bad with names) suggested.

Ok, getting there. But I still don't know how to call the program. It's a class, so I don't think I can do: "do vfpxtab with input_table". Or can I?

Thanks,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform