Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Hiding '.NULL.' in grids
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00033213
Message ID:
00033337
Views:
48
> >>I'm using updatable views. When I display the results of a left > outer join, some of the fields contain .NULL.. This does not create > any problems with correct operation of my program. Often I am using a > >Try > >SET NULLDISPLAY TO " " > >in your startup code > > Thank you -- works perfectly! I guess it is time for me to read my VFP > reference manual again. :) > Can I suggest that this is the "neatest" level you take it to. I had a lot of wasted time recently with VFP5 crashing out in W95 with Fatal Page Faults. This was on a form where the first page was for navigation, and the second for the current record's details. Very frequently it would blow up, and with that sort of crash you aren't left with many clues :-( My "crime" - I was NVL()ing the OJ field on the fly in the View SQL definition to remove any .NULL.s before they appeared. Taking this out left all running as it should. Kevin
Previous
Reply
Map
View

Click here to load this message in the networking platform