Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Suppress a field value in a Grid ??
Message
 
 
À
26/08/1999 16:05:19
Bruce Covey
Home Depot Television
Atlanta, Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00258125
Message ID:
00258136
Vues:
14
>I have a query that returns its results (cursor) as a GRID in a second form. The first GRID field contains a .T. flag if a resource is checked-out of my VideoTape library, otherwise I simply want the field to remain blank. It is currently being filled with .NULL. if the resource is NOT checked.
>
>Is it possible to suppress the display of the .NULL. value in this grid column ??
>
>Thanks.

Might be easier to modify your query:

Select nvl(CheckedOut, .F.) as CheckedOut...

In the InputMask of the column, put the letter Y. This will display the status as either a Y or N. Change Sparse to .F. If you just have to have the NO be represented by a blank:

Select iif(nvl(CheckedOut, .F.), "Y", " ") as CheckedOut...
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform