im not sure but could you select max(eventdt) instead of selecting them all and sorting descending?
might be a faster lookup too that way ----- Original Message ----- From: "Bernard Lis" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, August 06, 2004 1: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 >
