Re: conditional statement

[Pragya Chandra <pchandra@FASTENAL.COM>]

or you could even use this:


        if #Empl_Record = 1 AND
             NOT($Status    = 'A'
                OR $Status = 'Q'
                OR $Status = 'P'
                OR $Status = 'U')
                do Select-Address
        else
                do Fetch-Address
      end-if

> -----Original Message-----
> From: Philippe DAVID [SMTP:Philippe.DAVID@GLENAT.COM]
> Sent: Wednesday, February 07, 2001 9:32 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: conditional statement
>
> I think you should use AND in place of OR in your test
>
> -----Message d'origine-----
> De : Cadenas, Maria (MT) [mailto:MCadenas@DOW.COM]
> Envoyé : mercredi 7 février 2001 16:30
> À : SQR-USERS@list.iex.net
> Objet : conditional statement
>
>
> I'm having trouble with the following conditional sentence.  I need a
> statement that would select only employees with an employee record = 1 and
> a
> status NOT equal to A,Q,P, or U.  It is the OR clause that is giving me
> trouble. Any suggestions?
>
> if #Empl_Record = 1 AND ($Status    <> 'A'
>                          OR $Status <> 'Q'
>                          OR $Status <> 'P'
>                          OR $Status <> 'U')
>         do Select-Address
> else
>         do Fetch-Address
> end-if