All a matter of preference. I turn it ON always, and turn it off only when the processing would work better, which is seldom. Since R:Base does not support Empty strings, this is critical. As most data processing I have been involved in could care less about the concept of NULL, EQNULL ON eliminates a lot of complexity. I run with ZERO ON also so calculations won't blow up on NULLS. My opinion? If it ain't filled in, it is zero.
On the rare occasions where SQL's three-state logic makes sense, I can turn on these features. But I definitely do not consider these features obsolete. They allow easy to maintain code where three value complexity is unnecessary. -- Dennis McGrath mailto:[EMAIL PROTECTED] -- Tools for R:BASE programmers http://www.enteract.com/~mcgrath/dennis -- Full time consultant with SQL Resources mailto:[EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Albert Berry Sent: Tuesday, July 23, 2002 9:01 AM To: [EMAIL PROTECTED] Subject: RE: EQNULL EQNULL, I think, was retained for backwards compatibility to very early versions of R:Base, which treated NULLs almost as if they were Empty Strings rather than NULL. I never set it on, myself. Thomas J Cimicato <[EMAIL PROTECTED]> wrote: >I'm sure this conversation has been had before in detail but I wouldn't >mind a quick comment on the following questions. > >What is the prevailing thought on the use of the EQNULL setting?? >Should you code for it ON or OFF as a standard? (Off seems to be the >default in the rbase.cfg file. ) >When would you not want NULL to equal NULL?? > >Thomas J Cimicato >President >Integrated Check Technologies >Collect-A-Check, Inc. >------------------------------------------------------------ >Bus:800.338.0676 x3120 > � � � �614-55-CHECK >Fax:614-552-4439 >Mailto:[EMAIL PROTECTED] >www.ICheckTech.com > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
