Hi Larry, How about a UNION with a dummy final row in the SELECT clause of the DECLARE CURSOR statement? You can check for the dummy row instead of relying on "end-of-data".
Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForenSys.ca 416 512 6950 > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig > Sent: September 15, 2005 11:44 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Suppressing End-of-data encountered message. > > I'm trying to suppress the message End-of-data encountered, which is produced > by the FETCH statement when the end of the cursor has been reached. I want to > do this while leaving the general ERROR MESSAGE setting turned on. By > checking > the error codes, I have determined that this message is #406, but even when I > issue SET ERROR MESSAGE 406 OFF, the message is still printed. > > Any suggestions? > -- > Larry
