If you are within a C-type program, the SQLCA
contains a field that contains the number of rows updated. Look at the Application Developer’s
Guide for more information. Thank
You Stephen
P. Karniotis Product Architect Compuware Corporation Direct: (248)
865-4350 Mobile: (248)
408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -----Original
Message----- Is
there a way to access 'something' that would
denote if any rows were updated? Feedback lets you set up
how many rows will be effected before a count is returned, but WHERE is this
number coming from? I have found a 'Returning'
clause of the update statement, but I don't really want a value returned, just
how many rows were affected. We have a situation where we want to know
if an update statement actually updated any rows or in fact did not find a row
that met the condition. SqlPlus will return '0 rows updated.' Does
anyone know where 0 is coming from? Thanks you for your help. Laura The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. |
Title: UPDATE Results
- UPDATE Results Burton, Laura L.
- RE: UPDATE Results Jamadagni, Rajendra
- RE: UPDATE Results Burton, Laura L.
- Re: UPDATE Results Karniotis, Stephen
- Re: UPDATE Results Stephane Faroult