General information
Category:
Coding, syntax & commands
> >>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only