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 > >
