David,
You're right and it goes back pre 4.5 how this "evolved" in this fashion. The tip off that a little rewrite is needed is where the check for ready is:
(status = " " OR status IS NULL)
i.e., I don't even know what the value is!
It's like Sex = "M", "F" or NULL
Thanks,
Dennis *****
At 10:50 AM 2/24/2005 -0500, you wrote:
Dennis
In your case, I wouldn't have a valid master code like this set to NULL. I'd create a one character value which means "READY"!
But, different strokes.....
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Dennis Fleming" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, February 23, 2005 5:18 PM Subject: [RBG7-L] - Re: EQNull
> David, > > I agree with you, but... > > I have a status setting (TEXT 1) in scheduled work which is initially blank > which means there is nothing preventing it from being done. In a lookup > table a blank equates to "Ready", and all other single character codes mean > it's waiting for something (parts, labor, approval, etc.). > > If I set EQNULL ON, then the lookup is true and it works fine (null = > null). I have used converting to 7.1 from 6.5 as an opportunity to rewrite > a lot of "suspect" code, but this is one area I haven't. I don't see a > problem where two null values are compared equal. I was just curious if > others have run into a problem with EQNULL ON. > > Thanks, > > Dennis > ***** > > > At 04:56 PM 2/23/2005 -0500, you wrote: > >Dennis > > > >On principal, I just don't mess with this setting. NULL should NOT be > >treated as equal to NULL in my mind: X = Y is not the same as X IS NULL. > > > > > >David Blocker > >[EMAIL PROTECTED] > >781-784-1919 > >Fax: 781-784-1860 > >Cell: 339-206-0261 > >----- Original Message ----- > >From: "Dennis Fleming" <[EMAIL PROTECTED]> > >To: "RBG7-L Mailing List" <[email protected]> > >Sent: Wednesday, February 23, 2005 2:00 PM > >Subject: [RBG7-L] - EQNull > > > > > > > I realize that we (I) tend to recycle some prior discussions. > > > Dr R's FTE article is certainly helpful in Equal Null comparisons, but... > > > > > > There was a problem in an earlier 7.1 version where a blank is saved as a > > > Null and this has corrected in most instances. (It still reverts to a null > > > when selecting a blank in a screen form popup menu.) > > > > > > By setting EQNULL ON has been a good workaround for me, but my question > >is, > > > are there any drawbacks of leaving EQNULL on? > > > > > > TIA, > > > > > > Dennis > > > ***** > > > Dennis Fleming > > > IISCO > > > http://www.TheBestCMMS.com > > > Phone: 570 775-7593 > > > Mobile: 570 351-5290 > > > > > > > > Dennis Fleming > IISCO > http://www.TheBestCMMS.com > Phone: 570 775-7593 > Mobile: 570 351-5290 > >
Dennis Fleming IISCO http://www.TheBestCMMS.com Phone: 570 775-7593 Mobile: 570 351-5290
