Question about checks for min and max values

[Henry Melancon]

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?

Henry


> -----Original Message-----
> From: Jeff Harrison [mailto:jeffaharrison at yahoo.com]
> Sent: Wednesday, July 20, 2005 12:13 PM
> To: Henry Melancon; filepro-list at lists.celestial.com
> Subject: Re: Question about checks for min and max values
> 
> --- Henry Melancon <hemelancon at gifinc.com> wrote:
> 
> > Windows Server 2000 Service Pack 4 & Filepro 4.8.10
> >
> > Our QC Department checks the min and max values of
> > chemical data.  Can anyone tell me why
> > when I select zero as a minimum value, Filepro does
> > the comparison and allow a blank field to be
> > acceptable?
> >
> > For example, the specification for a given material
> > requires that a value be reported for the chemistry.
> >  When my data input clerk enters no value, I want
> > Filepro to flag this and print an exception report.
> >
> > Example:   IF    58 LT 59
> >          THEN   PRINT REPORT
> >
> > If 58 is a blank field and 59 is "0", I get no
> > report.
> >
> > This is probably very simple to experienced Filepro
> > user, but I am not an expert at programming in
> > Filepro.  It has been over 20 years since I have had
> > a programming class and I am very rusty.  Any help
> > would be appreciated.
> >
> > Henry W. Melancon
> > Documentation Supervisor
> > Quality Control Department
> > Gulf Island, L.L.C.
> > Houma, Louisiana   70359
> >
> 
> What are the field types (edits) for fields 58 and 59?
>  If they are both numeric or both alpha, then I would
> expect this to work.  If you are comparing apples to
> oranges, then you need to use FCP (Fruit Conversion
> Processing). :-)
> 
> Jeff Harrison
> jeffaharrison at yahoo.com
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com