Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to avoid showing .NULL. value in a grid?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00429711
Message ID:
00429860
Views:
15
>I have a grid based in a sql statement with an outer join. Fields with NULL values show the word .NULL. when not having a value. The NullDisplay property only works when that field has the focus. How can get a blank field in the whole grid instead of showing it only when the field has the focus?
>Please be as specific as possible.
>Thank you in advance.
>
>Ulises.

When doing a SQL Select, I prefer to use the NVL() function to convert nulls in the result to what I want displayed.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform