Question about checks for min and max values

[Jeff Harrison]

--- Nancy Palmquist <nlp at vss3.com> wrote:

> Jeff Harrison wrote:
> > --- Kenneth Brody <kenbrody at bestweb.net> wrote:
> > 
> > 
> >>Quoting Henry Melancon (Wed, 20 Jul 2005 12:36:44
> >>-0500):
> >>
> >>
> >>>The field types (edits) for fields 58 and 59 are
> >>
> >>both defined as type
> >>
> >>>"F".
> >>>
> >>>Filepro seems to be treating a blank field the
> >>
> >>same as zero.  Is this
> >>
> >>>correct?
> >>
> >>[...]
> >>
> >>A blank numeric field will compare equal to zero. 
> >>You can explicitly
> >>compare for blank by comparing for equal to "",
> >>which will be true only
> >>if the field is completely blank.
> >>
> >>--
> > 
> > 
> > I did a test with two .0 edits and I found that a
> > blank field is less than zero.  However, with two
> f
> > edits they are equal.  Is this a bug?  
> > 
> > For my tests I used the windows demo 5.010D9 DEMO
> 
> 
[snip]
 
> Lines 68 & 69 both test the null correctly and Lines
> 70 and 71 do not 
> test null when they are equal to zero.
> 
> These results do not match what Ken reported that
> zero and null will 
> test equal.  This is only true in some cases.
> 
> Evidence is clear.
> Nancy
> 

Yes, it seems that Ken was wrong.  I think that
happened once before :-)

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest ways to generate code for filePro exports and
imports.  

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com