Re: Update statement ...

Use dbinfo('sqlca.sqlerrd2') function. Best Regards, Octav On Thu, Jul 29, 1999 at 09:47:01AM -0700, Krishnakumar Nandagopal wrote: > > Hi, > > I've some basic doubt .... > > In a stored procedure, if I UPDATE a table .. > For eg, > UPDATE t_table1 > SET col1 = "value" > WHERE col2 = 25 > > How do I find, if the above statement affected any rows of the table > "t_table1"???? > > Is there any flags set by the system ???? > > Thanks, > krishnakumar > _____________________________________________________________ > Do You Yahoo!? > Free instant messaging and more at http://messenger.yahoo.com -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com