Thanks to all who replied. Yes, I had a DUH moment because I was told there would only be one record per client per event code. When I discovered that wasn't the case, they said OH YA! But then I continued along the same road instead of thinking about starting over, and was surprised that I got the right result. Anyhow, thanks again. Bernie Lis ----- Original Message ----- From: "David M. Blocker" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, August 07, 2004 11:45 AM Subject: [RBASE-L] - Re: too many rows returned
> Bernie > > I read the whole string on this subject, but didn't see anyone show you the > full solution to what you want, which is to get the LATEST record by eventdt > value for a particular clno value and eventcd = 'stc'. > > Here's what you want > > SELECT Max(EventDt) INTO Event IND vI1 FROM Docket WHERE Clno = .clnum and > eventcd = 'stc' > > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 > ----- Original Message ----- > From: "Bernard Lis" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, August 06, 2004 4:42 PM > Subject: [RBASE-L] - too many rows returned > > > > Can I count on this happening? > > > > set var event date > > sel eventdt into event from docket where clno=.clnum and eventcd = 'stc' > > order by eventdt=d > > > > Although it results in the error message "too many rows returned", I am > > getting the latest date in the variable event. > > This is exactly what I want, can I count on this for all cases? > > > > Bernie Lis > > > > > >
