That 'splains it. I learn something new every day... especially when I stick my nose out and get it bloodied...
> -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis > Sent: Tuesday, July 05, 2005 4:34 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Select Max question > > Claudine, > There are multiple payment records for a given order > Each payment is assigned a PaymentNo. > I need to know the highest PaymentNo in order to insert the next payment. > Bernie > ----- Original Message ----- > From: "Claudine Robbins" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Tuesday, July 05, 2005 3:05 PM > Subject: [RBG7-L] - RE: Select Max question > > > > Bernie, > > > > This isn't going to work with a where clause... > > > >> -----Original Message----- > >> From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard > Lis > >> Sent: Tuesday, July 05, 2005 1:47 PM > >> To: RBG7-L Mailing List > >> Subject: [RBG7-L] - Select Max question > >> > >> set var MaxPaymentNo int=null > >> SELECT MAX(PaymentNo) INTO MaxPaymentNo IND iv1 FROM PAYMENTS WHERE > >> OrderNo > >> = 9596096 > >> > >> sqlcode returns 0 even though the record does not exist. > >> MaxPaymentNo becomes 0 and the indicator iv1 is also 0 > >> > >> Is this the way it's supposed to be? > >> > >> Bernie Lis > > > >
