SQL UPDATE statements (confused again)

[K]

Confused again!  Okay revdb_execute return the number of rows modified.  This would make a 0 (zero) return value  a indeterminate state.  Since one cannot tell if 0 (zero) rows where modified or if a error occured preventing the statement from executing.  How does one tell the difference?

K


-==-=-=-=-=-=-==-=-=-=-=-=-=-=-==-=-=-=-=-=-
Disclaimer:

Any resemblance between the above views and those of my
employer, my terminal, or the view out my window are purely
coincidental. 
Any resemblance between the above and my own views is non-deterministic.

 The question of the existence of views in the absence of anyone to hold
them
is left as an exercise for the reader. The question of the existence of
the reader
 is left as an exercise for the second god coefficient. 
(A discussion of non-orthogonal, non-integral polytheism is beyond the
scope of this article.)



 --- On Tue 06/01, K < nnoydb at excite.com > wrote:
From: K [mailto: nnoydb at excite.com]
To: use-revolution at runrev.com
Date: Tue,  1 Jun 2004 10:35:35 -0400 (EDT)
Subject: SQL UPDATE statements

<br><br><br>According to my understanding of the database API revExecuteSQL is to be used for statements like INSERT and UPDATE.  This statements error infromation is returned in "the result". I cannot seem to find a way to get the number of rows modified in a reExecute query that uses UPDATE.  Any ideas?  Is this simply a oversite?  Is there a API I am unaware of? <br><br>K<br><br><br><br><br>-==-=-=-=-=-=-==-=-=-=-=-=-=-=-==-=-=-=-=-=-<br>Disclaimer:<br><br>Any resemblance between the above views and those of my<br>employer, my terminal, or the view out my window are purely<br>coincidental. <br>Any resemblance between the above and my own views is non-deterministic.<br><br> The question of the existence of views in the absence of anyone to hold<br>them<br>is left as an exercise for the reader. The question of the existence of<br>the reader<br> is left as an exercise for the second god coefficient. <br>(A discussion of non-orthogonal, non-integral polytheism is beyond the<br>scope of this article.)<br><br><br><br>_______________________________________________<br>Join Excite! - http://www.excite.com<br>The most personalized portal on the Web!<br>_______________________________________________<br>use-revolution mailing list<br>use-revolution at lists.runrev.com<br>http://lists.runrev.com/mailman/listinfo/use-revolution<br>

_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!