Don't confuse "Value" with "Visual Representation". Null is Null (unless EqNull is set ON/OFF, but this only affects calculations is expressions).
When you set Null to '-0-' , when you "see" it on screen or in report, the "value" of it is nothing or null. If you don't want to "see" it, just set it to BLANK like Set var vBlank = (Char(160)) Set Null .vBlank and you won't "see" it. ----- Original Message ----- From: "Matthew Burke" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Friday, March 28, 2008 5:03 PM Subject: [RBASE-L] - How do I make NULL truly NULL? >I imagine there's a simple way to do this but I can't manage to figure out > how. > > > > I try to use R> SET NULL '' and it does nothing, NULL keeps whatever value > it previously had stored, in my case that is -0- which I believe is the > default. I want NULL to be void of any and all data, both visually and > logically, not represented by some text I define. > > > > Matthew Burke > > Pioneer Bank - IT Department > > Computer Systems Technician > > 505-627-4415 > > > > This email contains PRIVILEGED AND CONFIDENTIAL information intended only > for the use of the addressee(s) named above. If you are not the intended > recipient of this email, or the employee or agent responsible for delivering > it to the intended recipient, you are hereby notified that any dissemination > or copying of this email is strictly prohibited. If you have received this > email in error, please notify us by replying to this email and delete this > email from your records. Thank you for your cooperation. > > > >
