Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Suppress a field value in a Grid ??
Message
 
 
To
26/08/1999 16:05:19
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00258125
Message ID:
00258136
Views:
13
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform