This topic usually results in 30 or so responses. The idea is to control when it's OK for a column to having nothing as opposed to something. i.e., value for sex must be M or F, but a second phone number can be blank/null. I like EqNull On, and I also like Zero On so reports will total values properly even if blank/null.
I recall that SQL doesn't go along with some of the RBase conventions and I believe comparing to Nulls is a no-no. But others will correct me if I'm wrong. (I realize that blanks and nulls are different, but I've never had any luck explaining this to my users.) Dennis **** At 10:27 PM 7/22/02 -0400, you 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/ > > Dennis Fleming IISCO http://www.TheBestCMMS.com Phone: 570 775-7593 Fax: 570 775-9797 ================================================ 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/
