Re: Printing Min and Max values

[Ramesh Subramanian <sramsh@HOTMAIL.COM>]

Hi Joe ,
          The reason why the same sql statement doestn't work in
  your sqr is due to the fact that the date format is different in sqr and
in Oracle sqlplus . See what's the native date format used
in sqr and change your date value in that format .

  Mostly it should be  'DD/MM/YYYY'

Ramesh .




>From: Joe <jejohn1216@SURFREE.COM>
>Reply-To: SQR-USERS@list.iex.net
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Subject: Printing Min and Max values
>Date: Wed, 16 Jun 1999 07:23:12 -0700
>
>I am writing an SQR that has to look at a list of check numbers
>(PYMNT_ID_REF, char10) and print the beginning check and ending check
>numbers.
>
>My code is:
>
>    print 'First Check Number:' (+1,1)
>    print 'Last Check Number:' (+1,1)
>
>BEGIN-select
>min(PYMNT_ID_REF) &MNPIDREF
>   let $MNPIDREF = &MNPIDREF
>   print $MNPIDREF (-1,20) edit XXXXXXXXXX
>max(PYMNT_ID_REF) &MXPIDREF
>   let $MXPIDREF = &MXPIDREF
>   print $MXPIDREF (+1,20) edit XXXXXXXXXX
>   from PS_PAYMENT_TBL
>   where BANK_SETID = 'lalalalalala'
>     and BANK_CD = 'xyz'
>     and PYMNT_STATUS IN ('V','P')
>     and POSITIVE_PAY_STAT = 'S'
>     and PYMNT_DT = '1-MAY-99'
>END-select
>
>The code is in Process-Main, and the sql works like a charm when I test it
>in SQLPlus.
>
>However, nothing prints on the SQR.
>
>Any ideas?
>
>Thanks much.
>
>Joe Johnson
>jejohn1216@surfree.com
>
>
>;{)
>http://www.utdallas.edu/~jejohn
>--------------------------------------------------------
>$14.95 Unlimited Internet Access, http://www.surfree.com


_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com