Information générale
Catégorie:
Codage, syntaxe et commandes
> >>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement