Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid display
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Grid display
Divers
Thread ID:
00189955
Message ID:
00189955
Vues:
55
I have a table ( test1 ) with three fields
field1 c (40)
field2 c (40)
field3 c (80)

I have ten records in the table, field3 is empty in all but one record. I want to always display 2 columns in the grid ( field1, field2 ). If field3 is not empty, I need it to display on next grid line under field1, field2 as a single column. Is this possible ?

In order to get needed results now I have created temp table with
tmpField1 c (80)
tmpRecno I

I loop through ( test1 ) row by row and append blank in temp table then replace tmpField1 in the temp table with test1.field1 + test1.field2,tmpRecno with test1 recno()
if test1.field3 is not empty than I append blank to temp table and replace tmpfield1 with test1.field3,tmpRecno with test1 recno(). The grid recordsource is the temp table and displays one column, tmpField1.

I would rather find a way for grid to handle this without building temp table, my real scenerio has many more fields than this example.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform