Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making a 'grid' table
Message
De
29/05/1998 10:43:42
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00102892
Message ID:
00103103
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,

VFPXTAB.PRG source contains example how to call it: oMyxtab=createobject(..) and oMyxtab.makextab()
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform