Quiz Question:

[Ray Bailey]

Try This

Define Minimum-Field char*2 = FIELDA if FIELDA-DOL le FIELDB-DOL &
                                    and FIELDA-DOL le FIELDC-DOL &
                                    and FIELDA-DOL le FIELDD-DOL &
                         else FIELDB if FIELDB-DOL gt FIELDA-DOL &
                                    and FIELDB-DOL le FIELDC-DOL &
                                    and FIELDB-DOL le FIELDD-DOL &
                         else FIELDC if FIELDC-DOL gt FIELDA-DOL &
                                    and FIELDC-DOL gt FIELDB-DOL &
                                    and FIELDC-DOL le FIELDD-DOL &
                         else FIELDD

Define Minimum-Dol num*8   =  FIELDA-DOL if FIELDA-DOL le FIELDB-DOL &
                                        and FIELDA-DOL le FIELDC-DOL &
                                        and FIELDA-DOL le FIELDD-DOL &
                         else FIELDB-DOL if FIELDB-DOL gt FIELDA-DOL &
                                        and FIELDB-DOL le FIELDC-DOL &
                                        and FIELDB-DOL le FIELDD-DOL &
                         else FIELDC-DOL if FIELDC-DOL gt FIELDA-DOL &
                                        and FIELDC-DOL gt FIELDB-DOL &
                                        and FIELDC-DOL le FIELDD-DOL &
                         else FIELDD-DOL


This should help you out.  Make sure you get the "le" and "gt" operands in
the right place.

I As you can tell this is okay for four items but many more and this will
get very long winded.


Ray Bailey
Leicester
England


> -----Original Message-----
> From: owner-powerh-l@sphere.swau.edu
> [mailto:owner-powerh-l@sphere.swau.edu]On Behalf Of Ashvin Patel
> Sent: 14 January 1999 16:51
> To: 'powerh-l@lists.swau.edu'
> Subject: Quiz Question:
>
>
> I have a quiz subfile, having records with following structure:
> 								example
> 							            (value)
> 	FIELDA 	Alpha Numeric value X(2)	    	AA
>             FIELDB             Alpha Numeric value X(2)		BB
>             FIELDC             Alpha Numeric value X(2)		CC
>             FIELDD             Alpha Numeric value X(2)		DD
>             FIELDA-DOL      $					$1.20
>             FIELDB-DOL      $					$1.05
>             FIELDC-DOL      $					$1.50
>             FIELDD-DOL      $					$1.70
>
> I would like to create a new subfile with all of the above fields
> + Minimum
> field + Minimum $ value. i.e.
> 								example
> 							            (value)
>
> 	FIELDA 	Alpha Numeric value X(2)	    	AA
>             FIELDB             Alpha Numeric value X(2)		BB
>             FIELDC             Alpha Numeric value X(2)		CC
>             FIELDD             Alpha Numeric value X(2)		DD
>             FIELDA-DOL      $					$1.20
>             FIELDB-DOL      $					$1.05
>             FIELDC-DOL      $					$1.50
>             FIELDD-DOL      $					$1.70
>             Minimum-Field    Alpha Numeric value X(2)                BB
>             Minimum-Dol      $
> $1.05
>
> Incase of if the $value are the same, the order of the field
> value picked is
> in the order of a,b,c,d.
>
> Is there an easy way to do above in QUIZ.  Any tricks provided is greatly
> appreciated.
>
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = = = =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.
>

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.