Bernie: Although you may get the correct result, it is unpredictable and poor programming practice to use a command that gives you an error message. You should use: SELECT MAX(eventdt) INTO event INDICATOR vind1 FROM docket WHERE clno = .clnum and eventcd = 'stc' Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bernard Lis Sent: Friday, August 06, 2004 3:42 PM To: RBASE-L Mailing List 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
