Question about checks for min and max values

Fairlight fairlite at fairlite.com
Wed Jul 20 10:02:19 PDT 2005


Y'all catch dis heeyah?  Henry Melancon been jivin' 'bout like:
> 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.

If: 58 eq "" and 59 eq "0"
Then: print report

...depending on your exact need.


mark->
-- 
          *****   Fairlight Consulting's Software Solutions   *****
OneGate Universal CGI Gateway:                  http://onegate.fairlite.com/
FairPay PayPal Integration Kit:                 http://fairpay.fairlite.com/
RawQuery B2B HTTP[S] Client & CGI Debugger:     http://rawquery.fairlite.com/
Lightmail Mail Sending Agent:                   http://lightmail.fairlite.com/
FairView Image Viewer for Integration:          http://fairview.fairlite.com/


More information about the Filepro-list mailing list