what results do you get if you do this from the command prompt R>SET VAR clno to somthing
R>SELECT COUNT(*) INTO vRows FROM Docket + WHERE clno = .clnum and eventcd = 'stc' R>SHO VAR vRows if you get more that 1 row that why On 6 Aug 2004 at 16:42, Bernard Lis wrote: > 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 > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
